解法一 纯 JOIN select t.dept_no, j.emp_no, t.maxSalary from ( select d.dept_no as dept_no, max(s.salary) as maxSalary from dept_emp d join salaries s on s.emp_no = d.emp_no group by d.dept_no ) as t inner join ( select d.dept_no as dept_no, s.salary as salary, d.emp_no as emp_no from dept_emp d join sa...