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