题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
http://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select e.emp_no, d.emp_no as manager_no, s1.salary as emp_salary,s2.salary as manager_salary from dept_emp e inner join dept_manager d on e.dept_no = d.dept_no inner join salaries s1 on e.emp_no = s1.emp_no inner join salaries s2 on d.emp_no = s2.emp_no where s1.salary > s2.salary;
用内链接 将多表相联，注意使用同一张表2次的话，要进行不同的命名，工资表使用了两次，分别命名为s1 s2.
