排序窗口函数
dense_rank() over(order by Score desc) as 'Rank'
rank() over(order by Score desc) as 'Rank'
row_number() over(order by Score desc) as 'Rank'
-
dense_rank() over (partition by col 1 order by col2 desc) as col_order eg:1,1,2,3,4 重复连续
-
rank() over (partition by col 1 order by col2 desc) as col_order eg:1,1,3,4,5 重复不连续
-
row_number() over (partition by col 1 order by col2 desc) as col_order eg:1,2,3,4,5,连续不重复