获取学生最高的分数信息
select * from scores a where
not exists(select * from scores b where and a.score>v_b.score and a.name=b.name)
获取学生最高的分数信息
select * from scores a where
not exists(select * from scores b where and a.score>v_b.score and a.name=b.name)
转载于:https://www.cnblogs.com/lljinz/archive/2011/08/29/2157955.html