用开窗函数解决,外面套一层限制只要每个部门最高薪水员工的信息 select dept_no,emp_no,salary as maxSalary from (select emp.dept_no, emp.emp_no, sal.salary, row_number() over(partition by emp.dept_no order by sal.salary desc) as pay_number from dept_emp emp left join salaries sal on emp.emp_no =...