题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
select t.emp_no,t.salary from( select *,dense_rank() over(order by salary desc) as rn from salaries) as t where t.rn = 2;
select t.emp_no,t.salary from( select *,dense_rank() over(order by salary desc) as rn from salaries) as t where t.rn = 2;
相关推荐