[thelist] mysql - group by & order by

Joe Flintham list at menticulture.com
Sun Dec 7 07:00:46 CST 2008


r937 wrote:
> the way to solve this is to get a derived table which tells you the max
> timestamp for each group, and join that back to the table
>
>   
Thanks rudy, I found a similar solution and didn't know whether it was 
more effort than necessary, but your explanation clarifies everything, 
thanks!
Joe




More information about the thelist mailing list