select d1.dept_no,d1.emp_no,s1.salary from dept_emp d1
inner join salaries s1 on d1.emp_no=s1.emp_no
where s1.salary=(
    select max(s2.salary ) as maxSalary from dept_emp d2
    join salaries s2 on d2.emp_no=s2.emp_no
    and d2.dept_no=d1.dept_no )
order by d1.dept_no;