select name, max(score) from students group by name;
select s.* from students s where not exists(select 1 from students where name=s.name and score>s.score)select s.* from students s,(select name,max(score) as score from students group by name) v where s.name=b.name and s.score=v.score
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货