#方式1： SELECT emp.dept_no,emp.emp_no,MAX(salary) max_salary FROM dept_emp emp INNER JOIN salaries sal ON emp.`emp_no` = sal.`emp_no` GROUP BY dept_no ORDER BY dept_no ASC; #方式2：使用窗口函数 SELECT dept_no,sal.emp_no,salary FROM salaries sal INNER JOIN (SELECT *,ROW_NUMBER() OVER (PARTITION BY dept_no) rank_num FROM dept_emp) T_RAN_NUM ON sal.`emp_no` = T_RAN_NUM.emp_no WHERE rank_num = 1;