List:General Discussion« Previous MessageNext Message »
From:David Förster Date:January 30 2006 2:43pm
Subject:Sort before grouping
View as plain text  
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
Thread
Sort before groupingDavid Förster30 Jan
  • Re: Sort before groupingPeter Brawley30 Jan
  • Re: Sort before groupingMichael Stassen31 Jan