题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
select
e.emp_no,s2.salary-s1.salary as growth
from
(employees e
join
salaries s1
on
e.emp_no = s1.emp_no and e.hire_date = s1.from_date)
#把初始工资连接上
left join
(select emp_no,salary from salaries where to_date="9999-01-01")s2
on
e.emp_no = s2.emp_no
-- 把有最终工资的连接上
where
s2.salary is not null
order by
growth asc
华为成长空间 480人发布
