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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
