On Tue, Aug 18, 2009 at 2:53 PM, Leonardo Cezar<[email protected]> wrote: > <corte> > > SELECT EXTRACT(year FROM data), COUNT(id) > FROM teste > GROUP BY EXTRACT(year FRIN data);
Complementando: http://www.postgresql.org/docs/8.4/static/tutorial-sql.html -Leo -- Leonardo Cezar http://www.aslid.org.br http://postgreslogia.wordpress.com http://www.dextra.com.br/postgres _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
