select distinct a1.dept_no, a1.emp_no,salary from dept_emp a1 join salaries b1 on a1.emp_no=b1.emp_no, (select dept_no dep, max(salary) sala from dept_emp a join salaries b on a.emp_no=b.emp_no group by dept_no) as AA where b1.salary=AA.sala and a1.dept_no=AA.dep order by dept_no asc