Mysql 获取年级每个班前十学生的信息时间:2023-03-09 08:23:46 select * from Table1 a where 10>(select count(*) from Table1 where ClsNo=a.ClsNo and Score>a.Score) order by a.ClsNo,a.Score desc