Re: Need help with what I think is likely a simple query - for each distinct val, return only the record with the most recent date.

[Toby Corkindale <toby.corkindale@xxxxxxxxxxxxxxxxxxxx>]

On 13/09/11 10:54, Reid Thompson wrote:
> Could someone point me in the right direction..
> Thanks - reid
>
> Given the example data,
> how do I write a query that will give me the resultset:
[snip]
> I.E. for each distinct val, return the record with the most recent date.

Isn't it something simple like this?

SELECT val, max(date) GROUP BY val;


-Toby

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general