可以使用关联子查询。 select dept_no ,a.emp_no ,salary as maxSalary from dept_emp as a left join salaries as b on a.emp_no = b.emp_no where salary = ( select max(salary) from dept_emp c left join salaries d on c.emp_no = d.emp_no where a.dept_no = c.dept_no ...