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

入职工资连接现在工资，主要找出刚入职时候的工资，现在工资通过to_date='9999-01-01'一个条件就可以选出

select b.emp_no, salary2-salary1 as growth 
from ( 
       select emp_no, salary1 from(
       select emp_no, salary salary1, rank() over(partition by emp_no order by from_date) as rank
       from salaries 
       ) a
       where rank=1 
   )b
  right join 
   (
       select emp_no, salary salary2 
       from salaries  where to_date = '9999-01-01'
   ) d
    on b.emp_no = d.emp_no
    order by growth asc