题解 | 查找在职员工自入职以来的薪水涨幅情况
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
好吧一开始看半天没看懂题...才知道入职以来的薪资是按from_date算的。
select t1.emp_no, t1.salary - t2.salary as growth
from
(
select emp_no, salary
from salaries where to_date = '9999-01-01'
) t1
inner join
(
select s.emp_no, s.salary
from salaries s join employees e
where s.from_date = e.hire_date
) t2
on t1.emp_no = t2.emp_no
order by growth asc
传音控股公司福利 355人发布