获取所有部门中当前员工薪水最高的相关信息
获取所有部门中当前员工薪水最高的相关信息
http://www.nowcoder.com/questionTerminal/4a052e3e1df5435880d4353eb18a91c6
select dept_no, emp_no, max(salary) as salary from
(select d.dept_no as dept_no, d.emp_no as emp_no, s.salary as salary
from dept_emp d left join salaries s on d.emp_no = s.emp_no
where d.to_date = '9999-01-01'
and s.to_date = '9999-01-01' )
group by dept_no
投递微软等公司8个岗位 >
