select * from tabela where extract(year from data) = 2016 and extract(month from data) = 1;
select * from tabela where extract(year from data) = 2016 and extract(month from data) = 2;
select * from tabela where extract(year from data) = 2016 and extract(month from data) = 3;

select * from tabela where extract(year from data) = 2016;
select * from RESULTADO_ANTERIOR extract(month from data) = 1;
select * from RESULTADO_ANTERIOR extract(month from data) = 2;
select * from RESULTADO_ANTERIOR extract(month from data) = 3;