Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Ordering twice with group by

syber - 3:26 pm on Sep 5, 2010 (gmt 0)


Unless I'm missing something, wouldn't this be:

SELECT inventory_code, <aggregate functions>
FROM table
GROUP BY inventory_code
ORDER BY variation_number DESC, title

Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4196799.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com