题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
select
t.emp_no
,l-f growth
from (
select
emp_no
,to_date
,first_value(salary) over(partition by emp_no order by from_date asc) f
,first_value(salary) over(partition by emp_no order by from_date desc) l
from
salaries s
) t
where t.to_date = '9999-01-01'
order by growth
查看25道真题和解析