***BOGO*** Re: Sorted GROUP BY

["Perrin Harkins" <perrin@xxxxxxxx>]

On Tue, May 27, 2008 at 4:45 PM, Johan Solve <johan.solve@xxxxxxxxx> wrote:
> This is a classic problem.

It sure is.  Here are the classic solutions:
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html

I didn't look closely enough to be sure this applies to you, but in
most cases the LEFT JOIN approach works and performs well in MySQL.

- Perrin

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx