Q72878 – Tecnologia da Informação – Fundação Carlos Chagas 2015

SELECT * FROM TabPREV OF BD_PREV WHERE Data_Aposentadoria DATEDIFF ('01-Jan-2009', '31-Dec-2014') ORDER BY Valor_Aposentadoria;

SELECT * FROM TabPREV ORDER BY Valor_Aposentadoria WHERE Data_Aposentadoria IN “01-Jan-2009” && '31- Dec-2014';

SELECT * FROM TabPREV WHERE Data_Aposentadoria BETWEEN '01-Jan-2009' AND '31-Dec-2014' ORDER BY Valor_Aposentadoria ASC;

SELECT * FROM BD_PREV WHERE Data_Aposentadoria FROM TabPREV IS LIKE '01-Jan-2009' AND '31-Dec-2014' ORDER BY Valor_Aposentadoria ASC;

SELECT * FROM TabPREV ORDER BY Valor_Aposentadoria WHERE Data_Aposentadoria BETWEEN ('01-Jan-2009', '31-Dec-2014');