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

##较难？？
select emp_no , salary - min_sal as growth
from (
select emp_no , salary ,to_date, min(salary) over(partition by emp_No) as min_sal
from  salaries
)t
where to_date='9999-01-01'
order by 2