sql 取各组中的最大值

表test

id name record
1 a 88
2 b 76
3 c 66

4 c 90
5 b 77
6 a 56

7 b 77
8 c 67
9 a 44
获取a b c...的最大记录数的id号
select hh.id,hh.name,hh.record from test as hh where
hh.record = (select max(record) from test where name=hh.name)