题解 | #获取每个部门中当前员工薪水最高的相关信息#
获取每个部门中当前员工薪水最高的相关信息
https://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
select t.dept_no,t.emp_no,t.salary as maxSalary from
(select
d.dept_no,d.emp_no,s.salary,
rank() over(partition by d.dept_no order by s.salary desc) as sal_rank
from
dept_emp d,
salaries s
where
d.emp_no = s.emp_no) as t -- 先用窗口函数求出每个部门员工薪水排名
where t.sal_rank=1 -- 在筛选排名第一的信息
order by t.dept_no;
#刷题#