题解 | #员工其当前薪水比其manager薪水还高的信息#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select d.emp_no, dm.emp_no as manager_no, (select salary from salaries where emp_no = d.emp_no) as emp_salary, (select salary from salaries where emp_no = dm.emp_no) as manager_salary from dept_emp d join dept_manager dm on d.dept_no = dm.dept_no and d.emp_no != dm.emp_no where (select salary from salaries where emp_no = d.emp_no) > (select salary from salaries where emp_no = dm.emp_no)