1、row_number()
顺序排序
row_number() over (order by A asc(desc))
分组排序
row_number() over (partition by A order by B asc(desc)) 分组排序
2、rank()、dense_rank()
跳跃排序
rank() over (order by A asc(desc)) 跳跃排序 排名
顺序排序
dense_rank() over (order by A asc(desc)) 顺序排序
分组排序
dense_rank() over (partition by A order by B asc(desc)) 分组顺序排