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

with
    l as (
        select
            dept_no,
            d.emp_no,
            salary
        from
            dept_emp d
            join salaries s using (emp_no)
    )
select
    dept_no,
    emp_no,
    salary
from
    (
        select
            dept_no,
            emp_no,
            salary,
            row_number() over (
                partition by
                    dept_no
                order by
                    salary desc
            ) g
        from
            l
    ) a
where
    g = 1