本文共 540 字,大约阅读时间需要 1 分钟。
select grade ,dense_rank() over( order by grade desc )rank from student_grade
–结果
grade rank 100 1 100 1 922 89 3select grade,rank() over( order by grade desc )rank from student_grade
grade rank
100 1 100 1 92 3 89 4select grade,row_number() over( order by grade desc )rank from student_grade
grade rank
100 1
100 2
92 3
89 4
转载地址:http://vpoen.baihongyu.com/