SELECT d.dept_no, d.emp_no, s.salary AS 'maxSalary' FROM dept_emp AS d JOIN salaries AS s ON d.emp_no = s.emp_no GROUP BY dept_no HAVING salary = MAX(salary) ORDER BY d.dept_no ASC
