```SELECT l1.dept_no,l1.emp_no,l2.salary
FROM dept_emp as l1 LEFT join salaries as l2 on (l1.emp_no = l2.emp_no)
where l2.salary=(SELECT max(l4.salary)
FROM dept_emp as l3 LEFT join salaries as l4 on (l3.emp_no = l4.emp_no)
GROUP by l3.dept_no
HAVING l3.dept_no=l1.dept_no
)
order by l1.dept_no