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操作,属于常见和重点题目。
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操作,属于常见和重点题目。