select d.dept_no, d.emp_no, max(s.salary) as salaryfrom dept_emp as dleft join salaries as son s.emp_no = d.emp_nogroup by d.dept_nohaving count(d.emp_no) > 0order by d.dept_no wrong answer: 有个emp_no不对,可能不是拥有最大salary的emp_no, 而是dept中第一个emp select d.dept_no, d.emp_no, s.salaryfrom dept_emp as dleft...