题解 | 获取每个部门中薪水最高的员工相关信息
获取每个部门中薪水最高的员工相关信息
https://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
select dept_no,
emp_no,
salary
from
(select
A.dept_no,
A.emp_no,
B.salary,
(row_number() over (partition by A.dept_no order by B.salary DESC)) as rk
from
dept_emp A
left join salaries B on A.emp_no = B.emp_no
order by
B.salary
) as D
where rk = 1
order by dept_no ASC
阿里巴巴灵犀互娱公司福利 612人发布