题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#

select * from (
select CASE WHEN salaries.salary > (select salary from salaries where salaries.emp_no = dept_manager.emp_no )
THEN dept_emp.emp_no END,
CASE WHEN salaries.salary > (select salary from salaries where salaries.emp_no = dept_manager.emp_no )
THEN dept_manager.emp_no END,
CASE WHEN salaries.salary > (select salary from salaries where salaries.emp_no = dept_manager.emp_no )
THEN salaries.salary END,
CASE WHEN salaries.salary > (select salary from salaries where salaries.emp_no = dept_manager.emp_no )
THEN (select salary from salaries where salaries.emp_no = dept_manager.emp_no) END a
from dept_emp join salaries join dept_manager on
dept_emp.emp_no = salaries.emp_no and dept_emp.dept_no = dept_manager.dept_no
where dept_emp.emp_no not in (select emp_no from dept_manager)
) where a <>'None'