当前位置：网站首页>专用窗口函数rank, dense_rank, row_number

专用窗口函数rank, dense_rank, row_number

2022-04-23 06:04:00 【旺财2】 

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 班级表

版权声明
本文为[旺财2]所创，转载请带上原文链接，感谢
https://blog.csdn.net/wdyliuxingfeiyang/article/details/122232398

边栏推荐

猜你喜欢

随机推荐