题解 | #获取每个部门中当前员工薪水最高的相关信息#
获取每个部门中当前员工薪水最高的相关信息
http://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
感觉挺简单的
select t.dept_no, t.emp_no, max(t.salary) as maxSalary from ( select de.dept_no as dept_no, de.emp_no as emp_no, sa.salary as salary from dept_emp as de left join salaries as sa on de.emp_no = sa.emp_no ) as t group by dept_no;