三种分别是rank() over(),dense_rank() over(),row_number() over()
select wj_like_game,wj_chonezhi_money,rank() over (partition by wj_like_game order by wj_chonezhi_money desc ) rk, dense_rank() over (partition by wj_like_game order by wj_ChoneZhi_Money desc )dr, row_number() over (partition by wj_like_game order by wj_ChoneZhi_Money desc ) rn from wj_plyfor_game
从红圈中可以看得出，rank()over()当遇到相同的会停留，但是会跳跃，dense_rank() over()不跳跃，但是遇到相同的会停留，row_number() over()属于正常的。
原文：https://www.cnblogs.com/shiji7/p/12192005.html