[thelist] mysql - group by & order by

Joe Flintham list at menticulture.com
Sun Dec 7 03:05:08 CST 2008


Hi there

I have a single table, of the form

s_id     s_group     s_value     s_timeStamp
------------------------------------------------------
1          100            a               1228120256
2          100            b               1228120257
3          101            c               1228120258
4          102            d               1228120259
5          102            e               1228120260

I want to build a query which selects only the most recent item from 
each s_group

I've tried the very simple:

SELECT s_id, s_group, s_value, s_timeStamp FROM tbl
GROUP BY s_group
ORDER BY s_timeStamp DESC

unfortunately, this applies the GROUP BY before the ORDER BY, so returns 
the first item from each group (i.e. the one with the lowest s_id).

Any suggestions, assuming I've explained this sufficiently?

Thanks

Joe



More information about the thelist mailing list