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