题解 | 每个部门薪资排名前两名员工
每个部门薪资排名前两名员工
https://www.nowcoder.com/practice/89329eadd4a64126b1cd326ea0b7eff7
select department ,employee_name ,salary from (select department ,employee_name ,salary ,rank () over(partition by department order by salary desc) ranking from employees)rk where rk.ranking <=2
投递腾讯等公司7个岗位