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

先找到雇佣起始的工资

select*
from employees as e join salaries as s on e.emp_no = s.emp_no
where e.hire_date = s.from_date 

将此列表和新水表连接

select c.emp_no, (s.salary-c.salary) growth
from salaries as s join (
select*
from employees as e join salaries as s on e.emp_no = s.emp_no
where e.hire_date = s.from_date ) as c on s.emp_no = c.emp_no
where s.to_date='9999-01-01'
order by growth