https://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6?tpId=82&tags=&title=&difficulty=0&judgeStatus=0&rp=1
讲解: https://blog.nowcoder.net/n/44a5b3665ec14c29bcc1d210d174724f?f
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 AND d1.to_date='9999-01-01' AND s1.to_date='9999-01-01' 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.to_date='9999-01-01' AND s2.to_date='9999-01-01' AND d2.dept_no = d1.dept_no ) ORDER BY d1.dept_no;