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