题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
with t1 as (
select emp_no, salary,
lead(salary) over(partition by emp_no order by from_date) as salary2
from employees join salaries using(emp_no)
where emp_no in (select distinct emp_no from employees join salaries using(emp_no) where to_date = '9999-01-01')
)
select emp_no, sum(salary2 - salary) as growth from t1 group by emp_no order by growth
难怪小公司那么挑剔，让你们这些大佬把位置拿了