select d.dept_no, d.emp_no,max(s.salary)
from salaries s,dept_emp d
where s.emp_no = d.emp_no
GROUP by d.dept_no
ORDER by d.dept_no asc

mysql不能用这个