SQL rank() 、dense_rank() 、 row_number() 排名区别(附图和代码)
展示结果如下:
用法分别为:
select *,rank() over (order by score) as score_rank from employee ;
select *,dense_rank() over (order by score) as score_rank from employee;
select *,row_num() over (order by score) as score_rank from employee;
如是按照某个列分组,如a列,则如下:
..
原创
2021-08-30 14:30:54 ·
171 阅读 ·
0 评论