题解 | #获取每个部门中当前员工薪水最高的相关信息# 使用开窗函数还是挺简单

通过了所有算例，目前我看不出bug

select dept_no, emp_no, maxSalary
from
(select de.*, s.salary, max(salary) over(partition by dept_no) maxSalary
from dept_emp de join salaries s
on de.emp_no = s.emp_no
where s.to_date = '9999-01-01') t
where salary = maxSalary
order by dept_no;