Sort before grouping

[David Förster]

Hi,

is there any way to get datasets sorted before they're grouped by GROUP
BY()?

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
David

ps: please cc, I'm not on the list