题解 | #对所有员工的薪水按照salary降序进行1-N的排名#
#学习使用窗口函数rank,dense_rank,row_number select s.emp_no,s.salary, dense_rank() OVER (ORDER by salary DESC) as t_rank from (select * from salaries order by emp_no) as s
#学习使用窗口函数rank,dense_rank,row_number select s.emp_no,s.salary, dense_rank() OVER (ORDER by salary DESC) as t_rank from (select * from salaries order by emp_no) as s
相关推荐