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. - Mailing list pgsql-general
From
Toby Corkindale
Subject
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.
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