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

仅使用salaries表格实现功能：

        (select emp_no, salary from salaries
         where to_date='9999-01-01') as s1/*在职人员最新薪资*/
        left join
        (select emp_no, salary from 
               (select emp_no, salary,rank()over(partition by emp_no order by to_date) as r from salaries)
                 where r=1) as s2/*全体员工入职薪资*/
         on s1.emp_no=s2.emp_no
order by growth