select d.dept_no,d.emp_no,s.salary as maxSalaryfrom dept_emp d join salaries son d.emp_no = s.emp_nowhere (dept_no,salary) in ( select dept_no,max(salary) from salaries join dept_emp on dept_emp.emp_no = salaries.emp_no GROUP by dept_no)order by dept_no asc