题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
select a.emp_no,(b.salary-a.salary) growth
from
(
select
emp_no,
salary
from
salaries
where
(emp_no, from_date) in (
select
emp_no,
min(from_date)
from
salaries
group by
emp_no
)
) a
join
(
select
emp_no,
salary
from
salaries
where
(emp_no, to_date) in (
select
emp_no,
to_date
from
salaries
where to_date = '9999-01-01'
)
) b
on a.emp_no = b.emp_no
order by b.salary-a.salary
锐捷网络股份有限公司公司福利 443人发布
