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

with temp_table as (
    select de.dept_no, de.emp_no, sa.salary
    from dept_emp de
    join salaries sa on de.emp_no = sa.emp_no
)
select  a.dept_no,a.emp_no, a.salary as maxSalary from (
    select 
    dept_no,
    emp_no,
    salary ,
    row_number() over(partition by dept_no order by salary desc) ranking
from temp_table
) a
where a.ranking = 1;