题解 | #获取每个部门中薪水最高的员工相关信息#
获取每个部门中薪水最高的员工相关信息
https://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
select
d1.dept_no,
d1.emp_no,
d2.salary
from
dept_emp d1
left join salaries d2 on d1.emp_no = d2.emp_no
where
d2.salary = (
select
max(d4.Salary)
from
dept_emp d3
left join salaries d4 on d3.emp_no = d4.emp_no
where d1.dept_no=d3.dept_no
# group by d3.dept_no
)
order by d1.dept_no;
测试发现加不加`group by d3.dept_no`结果都一样
