题解 | #查找当前薪水详情以及部门编号dept_no#
查找当前薪水详情以及部门编号dept_no
http://www.nowcoder.com/practice/c63c5b54d86e4c6d880e4834bfd70c3b
- 首先确定最后要展示的属性：
select salaries.*, dept_manager.dept_no - 然后确定具体的数据来源：
from salaries inner join dept_manager
on salaries.emp_no = dept_manager.emp_no - 满足"当前:这个条件:
where salaries.to_data = "9999-01-01" and dept_manager.to_data = "9999-01-01"
具体的结果展示为：
select salaries.*, dept_manager.dept_no
from salaries inner join dept_manager
on salaries.emp_no = dept_manager.emp_no
where salaries.to_data = "9999-01-01" and dept_manager.to_data = "9999-01-01";
投递中国移动等公司10个岗位