mysql中有student,course,scorse 三张表, 计算每个人单科的最高成绩(学...答:select sid,cid,max(score) from score group by cid;然后分别和学生表、课程表联合查询取出科目名字和学生名字就ok了 写成单条sql:select * from (select s.sid,s.realname,a.cid,a.mscore from student as s right join (select sid,cid,max(score) as mscore from score group by cid)...