题解 | #获取每个部门中当前员工薪水最高的相关信息#
获取每个部门中当前员工薪水最高的相关信息
https://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
select dept_no,a.emp_no,salary from dept_emp as a inner join salaries as b on a.emp_no=b.emp_no where (dept_no,salary) in (select dept_no ,max(salary) from dept_emp as a inner join salaries as b on a.emp_no=b.emp_no group by dept_no ) order by dept_no
曼伦商贸公司福利 163人发布
