Oracle–开窗函数函数排序rank、desc_rank、row_number
rank() over([partition by par_col] order by order_col):相同数据并列排序并且会跳过并列的应该有的次序
select salary,rank() over(order by salary desc) rn from employees
文章图片
dense_rank() over([partition by par_col] order by order_col):相同数据并列排序并且接下来的次序不会跳过
select salary,dense_rank() over(order by salary desc) rn from employees
文章图片
row_number() over([partition by par_col] order by order_col):相同数据不会进行并列排序
select salary,row_number() over(order by salary desc) rnfrom employees
【Oracle--开窗函数函数排序rank、desc_rank、row_number】
文章图片