题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
http://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
SELECT a.emp_no,b.emp_no manager_no,a.salary emp_salary,b.salary manager_salary
FROM (SELECT de.emp_no,s1.salary,de.dept_no
FROM dept_emp de,salaries s1
WHERE de.emp_no=s1.emp_no) a,
(SELECT dm.emp_no,s2.salary,dm.dept_no
FROM dept_manager dm,salaries s2
WHERE dm.emp_no=s2.emp_no) b
WHERE a.dept_no=b.dept_no
and a.emp_no!=b.emp_no
and a.salary>b.salary
查看14道真题和解析