–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 –跳跃排序
–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 –跳跃排序