1、排序
--rank为重复不连续,dense_rank为重复连续,row_number不重复,按顺序下来
row_number () over (partition by ... order by ...)
dense_rank() over (partition by ... order by ..
1、排序
--rank为重复不连续,dense_rank为重复连续,row_number不重复,按顺序下来
row_number () over (partition by ... order by ...)
dense_rank() over (partition by ... order by ..