查询每个人单科成绩的最高值

select * from Stu Stu1, (select stu_id, max(score) as maxscore from Stu group by stu_id) Stu2
where Stu1.stu_id = Stu2.stu_id and Stu1.score = Stu2.maxscore;