mysql是指取到的那一行,并不是包含最大分数的那一行
SELECT a.* ,c.* FROM tbstudent a INNER JOIN
(SELECT SUBJECT,MAX(score) score FROM tbstudent GROUP BY SUBJECT)b ON a.SUBJECT=b.SUBJECT AND a.score=b.score INNER JOIN tbclass c ON a.classid=c.classid WHERE c.classname=‘二四’ ORDER BY a.score;
先单表分组科目,拿个每门科目的最高分,当做其表,在与老表进行inner join 条件为科目和分数即可行