题解 | #获取每个部门中当前员工薪水最高的相关信息#

select 
    dept_no,
    emp_no,
    salary
from (
    select 
        t1.emp_no,
        t1.dept_no,
        t2.salary,
        row_number() over(partition by dept_no order by salary desc) rn
    from dept_emp t1
    inner join salaries t2
    on t1.emp_no = t2.emp_no
    where t1.to_date = '9999-01-01'
) t
where rn = 1
order by dept_no;