获取员工其当前的薪水比其manager当前薪水还高的相关信息
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select t2.emp_no emp_no,t1.emp_no manager_no,t2.salary emp_salary,t1.salary manager_salary from #部门经理的薪水 (select dm.dept_no dept_no,dm.emp_no emp_no,s.salary salary from dept_manager dm join salaries s on dm.emp_no=s.emp_no)t1 , #非部门经理的薪水 (select de.dept_no dept_no,de.emp_no emp_no,s.salary salary from dept_emp de join salaries s on de.emp_no=s.emp_no where de.emp_no not in (select dm.emp_no from dept_manager dm))t2 where t1.dept_no=t2.dept_no and t1.salary<t2.salary