oracle重复值排序问题

1. 分析函数dense_rank()
   分析函数还支持分组排序 dense_rank() over(partition by xxx order by Score desc )

select grade ,dense_rank() over( order by grade desc )rank from student_grade

–结果
grade rank
100 1
100 1
922
89 3

2. 分析函数rank()
   rank() over( order by xxx desc) 重复分数并列 但会跳跃排序

select grade,rank() over( order by grade desc )rank from student_grade

grade rank
100 1
100 1
92 3
89 4

3. 分析函数row_number()
   –row_number() over( order by xxx desc) 重复分数并列 但会跳跃排序

select grade,row_number() over( order by grade desc )rank from student_grade

grade rank

100 1

100 2

92 3

89 4