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

SELECT
    t.dept_no,
    t.emp_no,
    t.salary
from
    (
        SELECT
            de.dept_no,
            de.emp_no,
            s.salary,
            DENSE_RANK() over (
                PARTITION by
                    de.dept_no
                order by
                    s.salary desc
            ) as rk
        from
            dept_emp de
            LEFT JOIN salaries s on s.emp_no = de.emp_no
    ) t
where
    t.rk = 1
ORDER BY
    t.dept_no