题解 | #查找在职员工自入职以来的薪水涨幅情况# 自连接，没用第一张表。。。
查找在职员工自入职以来的薪水涨幅情况
http://www.nowcoder.com/questionTerminal/fc7344ece7294b9e98401826b94c6ea5
翻得太靠上，没看到第一张表。。。用了自联结做
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;
