题解 | #查找最晚入职员工的所有信息#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
http://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
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
腾讯云智研发成长空间 5079人发布
查看25道真题和解析