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

select
a.emp_no,
a.salary-b.salary as growth
from
(select emp_no,
salary
from
salaries
where
to_date="9999-01-01"
)a
inner join
( select emp_no,
salary,
from_date
from
salaries
where
to_date="9999-01-01"
)b
on a.emp_no=b.emp_no
inner join
(
select emp_no,
hire_date
from
employees
)c
on b.emp_no=c.emp_no and b.from_date=c.hire_date
order by growth asc