Oracle三种rank的区别
rank:1 2 2 2 2 6rank() over([partition by col1] order by col2) denseRank:1 2 2 2 2 3dense_rank() over([partition by col1] order by col2) rowNumber:1 2 3 4 5 6row_number() over([partition by col1] ordoracle账号er by col2)
Oracle三种rank的区别
rank:1 2 2 2 2 6rank() over([partition by col1] order by col2) denseRank:1 2 2 2 2 3dense_rank() over([partition by col1] order by col2) rowNumber:1 2 3 4 5 6row_number() over([partition by col1] ordoracle账号er by col2)