select dept_no,dept_emp.emp_no,salary
from dept_emp join salaries on dept_emp.emp_no=salaries.emp_no
where (dept_no,salary) in 
(select dept_no,max(salary) salary
from dept_emp join salaries on dept_emp.emp_no=salaries.emp_no
group by dept_no)
order by dept_no