每个班的前10名的MySQL 查询方法 select a.class,a.score from student a where (select count(*) from student where class=a.class and a.score<score)<3 order by a.class,a.score desc;