select * from tb a
where not exists(
select * from tb
where name=a.name and score>a. score
)
----or:
select * from tb a inner join
(select name,score=max(score)
from tb group by name) b
on a.name = b.name and a.score=b.score
where not exists(
select * from tb
where name=a.name and score>a. score
)
----or:
select * from tb a inner join
(select name,score=max(score)
from tb group by name) b
on a.name = b.name and a.score=b.score
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货