经过了各种数据集的情况，我这个应该是都没问题了吧 SELECT ms.dept_no, s2.emp_no, ms.maxSalaryFROM salaries s2, dept_emp d2,(SELECT d1.dept_no, MAX(s1.salary) AS maxSalaryFROM dept_emp d1 JOIN salaries s1 ON d1.emp_no = s1.emp_noGROUP BY d1.dept_no) msWHERE s2.salary = ms.maxSalary AND s2.emp_no = d2.emp_no AND d2.dept_no = m...
投递网易等公司6个岗位