Mysql 获取年级每个班前十学生的信息

分类: IT文章 • 2024-03-04 09:35:56

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