httpwebwitch - 4:36 pm on Mar 8, 2011 (gmt 0)
now I've got this:
select * from table where number in (select max(number) from table group by letter)
it works - I've got the rows I want.
This seems kludgy to me. doing one select to get a list of ids, then another "IN" select to get the rows? it works, but isn't there a better way?