题解 | 获取每个部门中薪水最高的员工相关信息
获取每个部门中薪水最高的员工相关信息
https://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
select
t1.dept_no,
t1.emp_no,
t1.salary
from
(
select
de.dept_no,
de.emp_no,
s.salary,
RANK() OVER (
PARTITION BY
de.dept_no
ORDER BY
s.salary DESC
) AS sal_rank
from
salaries s
join dept_emp de on de.emp_no = s.emp_no
) as t1
where
sal_rank = 1
