题解 | 每个部门薪资排名前两名员工
每个部门薪资排名前两名员工
https://www.nowcoder.com/practice/89329eadd4a64126b1cd326ea0b7eff7
select
department
,employee_name
,salary
from
(
select
rank() over(partition by department order by salary desc ) as rk
,employee_name
,department
,salary
from employees
) t1
where rk <= 2
order by department asc , salary desc
查看9道真题和解析