题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
select
main.emp_no,
main.salary - salaries.salary as growth
from
salaries main
left join employees on main.emp_no = employees.emp_no
left join salaries on salaries.emp_no = main.emp_no
and employees.hire_date = salaries.from_date
where
main.to_date = '9999-01-01'
order by
growth
投递京东等公司10个岗位