题解 | 开窗函数的强大！（在职员工入职以来薪资涨幅情况）
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
select emp_no,growth from ( select emp_no,to_date,last_value(salary)over(partition by emp_no order by from_date )-first_value(salary)over(partition by emp_no order by from_date ) as growth from salaries ) a where to_date='9999-01-01' order by growth
投递TP-LINK等公司6个岗位 >