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

["Johan Solve" <johan.solve@xxxxxxxxx>]

On Tue, May 27, 2008 at 10:50 PM, Perrin Harkins <perrin@xxxxxxxx> wrote:
> 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.

Excellent pointer, thanks a lot!

In the comments I also found this:
http://jan.kneschke.de/projects/mysql/groupwise-max

"Group-wise maximum" - it's always easier when you know what to search for...

-- 
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad Stockholm Malmö
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
johan@xxxxxxxxxxx

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 | Fax +46 35-136801

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