宝塔服务器面板,一键全能部署及管理,送你10850元礼包,点我领取
PERCENT_RANK()
每行按照公式(rank-1) / (rows-1)进行计算。其中,rank为RANK()函数产生的序号,rows为当前窗口的记录总行数
CUME_DIST()
分组内小于、等于当前rank值的行数 / 分组内总行数
SELECT id, score , rank() OVER (ORDER BY score DESC) AS 'rank' , dense_rank() OVER (ORDER BY score DESC) AS 'dense_rank' , row_number() OVER (ORDER BY id DESC) AS 'row_number' , row_number() OVER (partition by score ORDER BY id DESC) AS 'row_number1' , PERCENT_RANK() OVER (ORDER BY score DESC) AS 'PERCENT_RANK' , CUME_DIST() OVER (ORDER BY score) AS 'CUME_DIST' , CUME_DIST() OVER (PARTITION BY score ORDER BY id) AS 'CUME_DIST1' FROM scores order by id
https://blog.csdn.net/Hzfeng666/article/details/109612895
最新评论