select b.dept_no,b.emp_no,b.salaryfrom(select de.dept_no,de.emp_no,s.salary from dept_emp de join salaries s ON de.emp_no=s.emp_no where de.to_date='9999-01-01' and s.to_date='9999-01-01') bwhere (b.dept_no,b.salary) IN (select c.dept_no,max(c.salary) as salary from (selec...