题解 | 获取每个部门中薪水最高的员工相关信息
获取每个部门中薪水最高的员工相关信息
https://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
WITH sub AS( SELECT dept_no, d. emp_no, salary, RANK()OVER(PARTITION BY dept_no ORDER BY salary DESC) rk FROM dept_emp d JOIN salaries s ON d.emp_no = s.emp_no ) SELECT dept_no, emp_no, salary FROM sub WHERE rk = 1;