> > > > Utilize DISTINCT ON (datetime) e ORDER BY datetime DESC. > > SELECT DISTINCT ON (datetime) description, value, datetime > FROM sua_tabela ORDER BY datetime DESC; > > Osvaldo > > > Acabou dando certo fazendo da seguinte forma ...
SELECT DISTINCT ON (description) description, value, datetime FROM sua_tabela ORDER BY description ASC, datetime DESC; Valew pela ajuda! Att Fabiano Fernandes
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
