题解 | 每个部门薪资排名前两名员工
每个部门薪资排名前两名员工
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) as paiming from employees ) as t1 where t1.paiming<=2 order by department asc ;
department是asc纯属跟着效果来的，题目描述笑死，还降序
查看17道真题和解析
