题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#

分别获取员工工资表以及领导工资表，两表联立查询即可

代码如下：

SELECT t1.emp_no emp_no, 
    t2.emp_no manager_no, 
    t1.salary emp_salary, 
    t2.salary manager_salary
-- 员工工资表
from (
    select de.emp_no, de.dept_no, sa.salary
    from dept_emp de, salaries sa
    where de.emp_no = sa.emp_no
    and de.to_date = '9999-01-01'
    and sa.to_date = '9999-01-01'
) t1
-- 领导工资表
inner join(
    select dm.dept_no, dm.emp_no, sa.salary
    from dept_manager dm, salaries sa
    where dm.emp_no = sa.emp_no
    and dm.to_date = '9999-01-01'
    and sa.to_date = '9999-01-01') t2
on t1.dept_no = t2.dept_no
where t1.salary > t2.salary