select t5.dept_no, t5.emp_no, t5.salary from ( select dept_no, max(salary) `salary` from ( select ...