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

select smax.emp_no,smax.salary-smin.salary growth
from (
    select e.emp_no emp_no,s.salary salary
    from salaries s,employees e 
    where s.emp_no = e.emp_no and e.hire_date = s.from_date
) smin,(
    select e.emp_no emp_no,s.salary salary
    from salaries s,employees e
    where s.emp_no = e.emp_no and s.to_date = '9999-01-01'
) smax
where smin.emp_no = smax.emp_no
order by growth asc

找到入职工资和当前工资就行