数据库SQL实战-12.获取所有部门中当前员工薪水最高的相关信息

select d.dept_no,d.emp_no,MAX(s.salary)
from dept_emp as d join salaries as s
on d.emp_no = s.emp_no
where d.to_date = '9999-01-01' and s.to_date = '9999-01-01'
group by d.dept_no

考查group by以及join操作，属于常见和重点题目。