题解 | sql219
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select de.emp_no, dm.emp_no manager_no, esa.salary emp_salary, msa.salary manager_salary from dept_emp as de inner join dept_manager as dm on de.dept_no=dm.dept_no inner join salaries as esa on de.emp_no=esa.emp_no inner join salaries as msa on dm.emp_no=msa.emp_no where esa.salary>msa.salary
投递字节跳动等公司7个岗位 >