2012/8/29 Anselmo Silva <anselmo....@gmail.com> > Não poderia ser somente "order by a.dt_mov"? >
Daria, só tem que lembrar de colocar no GROUP BY também: SELECT to_char(a.dt_mov, 'MM/YYYY') AS mes, sum(a.vlr_final) AS total FROM movdirhe a WHERE a.dt_mov between '01/01/2010' and '21/08/2012' GROUP BY mes, a.dt_mov ORDER BY a.dt_mov; Att. -- Matheus de Oliveira
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
