感觉挺简单的 select t.dept_no, t.emp_no, max(t.salary) as maxSalary from ( select de.dept_no as dept_no, de.emp_no as emp_no, sa.salary as salary from dept_emp as de left join salaries as sa on de.emp_no = sa.emp_no ) as t group by dept_no;