select rank=count(*), a1.studentname, a1.score
from student a1, student a2
where a1.score >= a2.score
group by a1.studentname, a1.score
order by a1.score
按某一字段排序生成名次
最新推荐文章于 2023-03-18 17:08:17 发布