题解 |

select s1.yg as emp_no,s2.emp_no manager_no,s1.salary emp_salary,s2.salary manager_salary
from (select s.emp_no as yg,salary,de.dept_no,dm.emp_no as jl
	  from salaries s,dept_emp de,dept_manager dm
      where s.emp_no = de.emp_no and dm.dept_no = de.dept_no and de.to_date = 
      '9999-01-01') s1,salaries s2
where s2.emp_no = s1.jl and s1.salary > s2.salary and s2.to_date = '9999-01-01';