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

select emp_no,salary-g growth
from
(select 
*,
first_value(salary) over (partition by emp_no order by from_date)  g
from salaries
)a
where to_date='9999-01-01'
order by growth