题解 | #获取每个部门中当前员工薪水最高的相关信息#
获取每个部门中当前员工薪水最高的相关信息
http://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
SELECT d.dept_no,d.emp_no,a.maxSalary FROM dept_emp d INNER JOIN salaries s ON d.emp_no=s.emp_no INNER JOIN (SELECT d.dept_no,MAX(s.salary) maxSalary FROM dept_emp d INNER JOIN salaries s ON d.emp_no=s.emp_no GROUP BY d.dept_no) a ON d.dept_no=a.dept_no WHERE s.salary=a.maxSalary ORDER BY d.dept_no
招商银行二面69人在聊
投递海尔等公司10个岗位