题解 | #查找最晚入职员工的所有信息#

select t1.emp_no,t2.emp_no as manager_no,t1.emp_salary,t2.manager_salary
from
(select
e.dept_no,e.emp_no,s.salary as emp_salary
from
dept_emp e join salaries s
on
e.emp_no=s.emp_no) t1
join
(select
m.dept_no,m.emp_no,s.salary manager_salary
from
dept_manager m join salaries s
on
m.emp_no=s.emp_no) t2
on
t1.dept_no=t2.dept_no and t1.emp_salary>t2.manager_salary