题解 | #薪水比其manager当前薪水还高的相关信息#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select dept_emp.emp_no,dept_manager.emp_no as manager_no,s1.salary as emp_salary,s2.salary as manager_salary from dept_emp,dept_manager,salaries s1,salaries s2 where dept_emp.emp_no=s1.emp_no and dept_manager.emp_no=s2.emp_no and dept_manager.dept_no=dept_emp.dept_no and s1.salary>s2.salary 把salaries用两次