SELECT de.dept_no,de.emp_no,qpd.maxSalary   from dept_emp de left join salaries sa on de.emp_no =sa.emp_no right join (SELECT de.dept_no,max(sa.salary) as maxSalary  from  dept_emp de left join 
salaries sa on de.emp_no =sa.emp_no GROUP BY de.dept_no ) as qpd on de.dept_no= qpd.dept_no and sa.salary=qpd.maxSalary order by de.dept_no asc

究极乱做 测试没过提交过了