#利用偏移分析函数将每次涨薪幅度加总就能获得入职以来总的涨薪幅度,这样的做法在处理降薪时也不会出问题select emp_no, sum(每次涨薪幅度) growthfrom (select emp_no, salary-lag (salary, 1) over (partition by emp_no order by salary) 每次涨薪幅度from salarieswhere emp_no = (select emp_no from salaries where to_date = '9999-01-01')#筛选在职员工) regroup by emp_noorder by gro...