题解 | #获取每个部门中当前员工薪水最高的相关信息# 使用开窗函数还是挺简单
获取每个部门中当前员工薪水最高的相关信息
http://www.nowcoder.com/questionTerminal/4a052e3e1df5435880d4353eb18a91c6
通过了所有算例，目前我看不出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;
