题解 | 查找在职员工自入职以来的薪水涨幅情况
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
思路：通过表连接找出入职薪资和最新薪资。注：要找到某行对应的另一列元素，可用表连接。
select t1.emp_no,(t2.salary-t1.salary) growth
from (select e.emp_no, s.salary
from salaries s right join employees e on e.emp_no=s.emp_no and s.from_date=e.hire_date
) t1 join
(
select emp_no, salary
from salaries
where to_date='9999-01-01'
) t2 on t1.emp_no=t2.emp_no
order by growth