题目:获取所有部门中当前员工薪水最高的相关信息,给出dept_no,emp_no以及其对应的salary,当前表示to_date=‘9999-01-01’
select de.dept_no,de.emp_no,MAX(s.salary) as salary
from dept_emp as de inner JOIN salaries as s
on de.emp_no=s.emp_no
where de.to_date='9999-01-01' and s.to_date='9999-01-01'
group by de.dept_no