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

select
    dept_no,
    emp_no,
    salary
from
    (
        select
            de.dept_no,
            de.emp_no,
            s.salary,
            rank() over (
                partition by
                    de.dept_no
                order by
                    s.salary desc
            ) as ranking
        from
            dept_emp de
            join salaries s on de.emp_no = s.emp_no
    ) newt
where
    ranking = 1