2010/4/23 Danilo - InfoCont Sistemas Integrados <[email protected]>
> Olá, > > Pela pergunta do Thiago, essa solução poderá apresentar problemas quando > houver anos diferentes. > > Exemplo: "ano/mês" de "2011/1" iria aparecer antes que "2010/12". > > copy t1 from stdin; Enter data to be copied followed by a newline. End with a backslash and a period on a line by itself. >> 2011 1 1836 >> 2012 3 1836 >> \. select * from t1; ano | mes | codfun ------+-----+-------- 2010 | 4 | 1593 2010 | 4 | 1836 2010 | 2 | 1836 2010 | 4 | 2398 2011 | 1 | 1836 2012 | 3 | 1836 (6 rows) select min(ano),min(mes),codfun from t1 group by codfun; min | min | codfun ------+-----+-------- 2010 | 4 | 2398 2010 | 4 | 1593 2010 | 1 | 1836 (3 rows) -- Marcelo Costa www.marcelocosta.net ------------------------------------------------- “You can't always get what you want”, Doctor House in apology to Mike Jagger
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
