题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
http://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
部门管理者薪资 (select dm.emp_no,dm.dept_no,s.salary from dept_manager dm join salaries s on dm.emp_no=s.emp_no) as ma 部门员工薪资 (select de.emp_no,de.dept_no,s.salary from dept_emp de join salaries s on de.emp_no=s.emp_no where de.emp_no not in (select emp_no from dept_manager)) as em 选择员工薪资更高的员工 select em.emp_no,ma.emp_no as manager_no,em.salary as emp_salary,ma.salary as manager_salary from (select dm.emp_no,dm.dept_no,s.salary from dept_manager dm join salaries s on dm.emp_no=s.emp_no) as ma join (select de.emp_no,de.dept_no,s.salary from dept_emp de join salaries s on de.emp_no=s.emp_no where de.emp_no not in (select emp_no from dept_manager)) as em on ma.dept_no=em.dept_no where em.salary>ma.salary
