sql语句小问题求教,,在线等,利马揭帖!50!

[crystal1024]

id name group1 score
1 aa 1 90
2 bb 1 84
3 bb 2 50
4 dd 2 30
5 cc 3 60
求每个组中分数最大的行信息,结果要这样:
1 aa 1 90
2 bb 2 50
3 cc 3 60

我这个菜啊...唉..!

[crystal1024]

select a.*
from xx a
inner join
(select group1,max(score) score1
from xx
group by group1) b
on a.group1 = b.group1
and a.score = b.score1
order by id
啊.想到了.抱歉各位!

[jinjazz]

select * from xx a where not exists
(select 1 from xx where group=a.group and score>a.score)

[这个人真的很懒]

学习...

[风河]

select id,name,group1,max(score)as maxscore from tbl_score group by group1