select *,
rank() over (order by 成绩 desc) as ranking,
dense_rank() over (order by 成绩 desc) as dese_rank,
row_number() over (order by 成绩 desc) as row_num
from 班级表
专用窗口函数rank, dense_rank, row_number
最新推荐文章于 2024-03-28 10:36:10 发布