--select *,row_number() over(partition by id order by email ) r from cs --分组排序
--select email,dense_rank() over(order by email asc) r from cs --连续排序
--select email,rank() over(order by email asc) r from cs --跳跃排序
原文：https://www.cnblogs.com/zhuyu139/p/9472597.html