select emp_no,salary-g growth from (select *, first_value(salary) over (partition by emp_no order by from_date) g from salaries )a where to_date='9999-01-01' order by growth