当前位置:数据库 > Oracle >>

Oracle三种rank的区别

Oracle三种rank的区别
 
rank:1 2 2 2 2 6

rank() over([partition by col1] order by col2)  

denseRank:1 2 2 2 2 3

dense_rank() over([partition by col1] order by col2)  

rowNumber:1 2 3 4 5 6

row_number() over([partition by col1] order by col2)  

 

 
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,