翻得太靠上，没看到第一张表。。。用了自联结做

select emp_no, max(currentsalary - salary) growth
from (
select a.*, b.salary currentsalary
from salaries a left join salaries b
on a.emp_no = b.emp_no
where b.to_date = '9999-01-01') t
group by emp_no
order by growth;