>I have a table of events at different locations and want to select the
>newest one for each location.
Famous & oft-asked, how to retrieve a groupwise-max values. See
David Förster wrote:
> is there any way to get datasets sorted before they're grouped by GROUP
> I have a table of events at different locations and want to select the
> newest one for each location.
> However "SELECT * FROM events GROUP BY location ORDER BY date DESC"
> gives me just some event per location and the result sorted by date.
> Thanks in advance
> ps: please cc, I'm not on the list
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.23/243 - Release Date: 1/27/2006