题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
http://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select t1.emp_no,manager_no,emp_salary,manager_salary from
(select dept_emp.emp_no,dept_emp.dept_no,salary as emp_salary from dept_emp inner join salaries
on dept_emp.emp_no = salaries.emp_no) as t1
,(select dept_manager.emp_no as manager_no,dept_manager.dept_no,salary as manager_salary from dept_manager inner join salaries
on dept_manager.emp_no = salaries.emp_no) as t2
(select dept_emp.emp_no,dept_emp.dept_no,salary as emp_salary from dept_emp inner join salaries
on dept_emp.emp_no = salaries.emp_no) as t1
,(select dept_manager.emp_no as manager_no,dept_manager.dept_no,salary as manager_salary from dept_manager inner join salaries
on dept_manager.emp_no = salaries.emp_no) as t2
where t1.dept_no = t2.dept_no and emp_salary > manager_salary;
拼接表 easy
