排序
rownumber() over (order by 1)
dense_rank() over (order by 1)
rank() over(order by 1)
分组排序
rownumber() over (partition by 1 order by 2)
dense_rank() over (partition by 1 order by 2)
rank() over(partition by 1 order by 2)
排序
rownumber() over (order by 1)
dense_rank() over (order by 1)
rank() over(order by 1)
分组排序
rownumber() over (partition by 1 order by 2)
dense_rank() over (partition by 1 order by 2)
rank() over(partition by 1 order by 2)