题解 | 每个部门薪资排名前两名员工
每个部门薪资排名前两名员工
https://www.nowcoder.com/practice/89329eadd4a64126b1cd326ea0b7eff7
select department,employee_name,salary from (select *,rank() over(partition by department order by salary desc) as rn from employees) t1 where rn<=2 order by department asc,salary desc
神人题目，越到后面约拉，题目描述写得一坨，rank()是并列跳跃。