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 ·
166 阅读 ·
0 评论