httpwebwitch - 3:44 pm on Mar 8, 2011 (gmt 0)

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

returns this:

3 one
5 four

isn't that weird.