摘要： 获取学生最高的分数信息select * from scores awherenot exists(select * from scoresb where and a.score>v_b.score and a.name=b.name) 阅读全文