SELECT d1.dept_no, d1.emp_no, s1.salary FROM dept_emp as d1 LEFT JOIN salaries as s1 ON d1.emp_no=s1.emp_no WHERE s1.salary = (SELECT MAX(s2.salary) FROM dept_emp as d2 LEFT JOIN salaries as s2 ON d2.emp_no=s2.emp_no where d2.dept_no = d1.dept_no ) ORDER BY d1.dept_no; 这样改就是
1

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务