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

select  DISTINCT t1.emp_no, t2.salary-t1.salary as growth from
(select e.emp_no,s.from_date,s.to_date,s.salary from employees e 
 INNER JOIN salaries s
on e.emp_no=s.emp_no and s.from_date=e.hire_date) as t1 -- 入职表
 INNER JOIN
(select e.emp_no,s.from_date,s.to_date,s.salary from employees e 
inner JOIN salaries s
on e.emp_no=s.emp_no and s.to_date='9999-01-01') as t2
where t1.emp_no=t2.emp_no 
order by t2.salary-t1.salary