题解 | #获取每个部门中当前员工薪水最高的相关信息#
获取每个部门中当前员工薪水最高的相关信息
https://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
select d.dept_no, d.emp_no, salary maxSalary from dept_emp d join salaries s on d.emp_no=s.emp_no where (dept_no,salary) in ( select dept_no,max(salary) from dept_emp d join salaries s on d.emp_no=s.emp_no group by d.dept_no) order by dept_no
简单直观
