题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
#利用偏移分析函数将每次涨薪幅度加总就能获得入职以来总的涨薪幅度,这样的做法在处理降薪时也不会出问题
select emp_no, sum(每次涨薪幅度) growth
from (
select emp_no, salary-lag (salary, 1) over (partition by emp_no order by salary) 每次涨薪幅度
from salaries
where emp_no = (select emp_no from salaries where to_date = '9999-01-01')#筛选在职员工
) re
group by emp_no
order by growth