mysql 取出班级前两名的成绩

SELECT * FROM score t1 WHERE(SELECT count(student_id) FROM score t2 where t2.class_id=t1.class_id and t2.score>t1.score)<2 ORDER BY class_id asc,score DESC;