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