前段时间才处理了一个业务场景。 就是 根据每天的增加或减少算出期末值。

with cte as
(
select 1 as id ,'2021-01-01' as rdate,100 as add_v,0 as sub_v union all
select 2,'2021-01-02',0,50  union all
select 3,'2021-01-03',0,30 union all
select 4,'2021-01-04',90,0
)

select id,rdate,add_v,sub_v,sum(add_v -sub_v ) over(order by id) as end_v
from cte a