题解 | #查找在职员工自入职以来的薪水涨幅情况#

先确定员工入职时间以及入职时薪水，再确定当前仍然就职的员工薪水，通过两个表的连接查询确定出薪水差值，然后顺序序排序

select t1.emp_no,t2.salary-t1.salary from 
(select employees.emp_no,salary,hire_date from employees, salaries 
where employees.emp_no = salaries.emp_no and employees.hire_date = salaries.from_date) t1
join 
(select employees.emp_no,salary, to_date from employees, salaries 
where employees.emp_no = salaries.emp_no and salaries.to_date = '9999-01-01') t2
on t1.emp_no=t2.emp_no
order by t2.salary-t1.salary ASC