题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
先创建两个虚拟表，把入职工资和涨薪之后的工资找出来，然后将两个虚拟表根据职工编号连接起来，考虑可能有离职的情况，所以用涨薪之后的表作为主表
select t2.emp_no,t2.salary2-t1.salary1 growth
from(select s1.emp_no,s1.salary salary1
from salaries s1 left join employees e1
on s1.emp_no = e1.emp_no
where s1.from_date = e1.hire_date) t1
right join
(select s2.emp_no,s2.salary salary2
from salaries s2 left join employees e2
on s2.emp_no = e2.emp_no
where s2.to_date = '9999-01-01') t2
on t1.emp_no = t2.emp_no
order by growth
#小白的技术进阶日记#
