题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
http://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
select st.emp_no, en.salary-st.salary growth
from (select employees.emp_no emp_no, salary
from employees right join salaries on employees.emp_no=salaries.emp_no
where hire_date=from_date) as st join
(select employees.emp_no emp_no, salary
from employees right join salaries on employees.emp_no=salaries.emp_no
where to_date='9999-01-01') as en on st.emp_no=en.emp_no order by growth
from (select employees.emp_no emp_no, salary
from employees right join salaries on employees.emp_no=salaries.emp_no
where hire_date=from_date) as st join
(select employees.emp_no emp_no, salary
from employees right join salaries on employees.emp_no=salaries.emp_no
where to_date='9999-01-01') as en on st.emp_no=en.emp_no order by growth