一、题目
二、代码
/*
两张表
第一张表记录 emp_no 与emp_salary dept_no 用于联结
第二张表记录 manager_no 与 manager_salary dept_no 用于联结
*/
select
table1.emp_no,(table2.emp_no) as manager_no,(table1.salary) as emp_salary ,(table2.salary) as manager_salary
from
(
select emp.emp_no,sa.salary,emp.dept_no
from dept_emp emp
right join salaries sa
on emp.emp_no = sa.emp_no
) table1
join
(
select de.dept_no,de.emp_no,sa.salary
from dept_manager de
left join salaries sa
on de.emp_no = sa.emp_no
) table2
on table1.dept_no = table2.dept_no
and table1.salary > table2.salary