题解 | #获取每个部门中当前员工薪水最高的相关信息#

SELECT d1.dept_no, d1.emp_no, s1.salary
FROM dept_emp as d1
INNER JOIN salaries as s1
ON d1.emp_no=s1.emp_no
WHERE s1.salary in (
    SELECT MAX(s2.salary)
    FROM dept_emp as d2
    INNER JOIN salaries as s2
    ON d2.emp_no=s2.emp_no
    AND d2.dept_no = d1.dept_no
)
ORDER BY d1.dept_no;  

找出每个部门薪水最高的，在所有员工中打印与最高薪水相同的薪水的信息，按照部门顺序输出