题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
http://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
select s1.emp_no,(s2.salary-s1.salary) as growth
from
(select salaries.emp_no,salaries.salary from salaries
where salaries.to_date='9999-01-01')as s2
inner join (select s.emp_no,s.salary from salaries as s
inner join employees as e
on e.hire_date=s.from_date and e.emp_no=s.emp_no)as s1
on s2.emp_no=s1.emp_no
ORDER BY growth;
投递比亚迪等公司10个岗位 >
米哈游公司福利 3760人发布