Page is a not externally linkable
- Code, Content, and Presentation
---- GROUP BY, returning the highest something per group?
httpwebwitch - 3:44 pm on Mar 8, 2011 (gmt 0)Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4278351.htm
I know I can do SELECT MAX(number)
but that doesn't return the word column
I'd never noticed this:
SELECT MAX(number),word FROM table GROUP BY letter
isn't that weird.
Brought to you by WebmasterWorld: http://www.webmasterworld.com