17,086
社区成员
发帖
与我相关
我的任务
分享
with temp as(
select 1 a,3 b,15 c from dual
union all
select 2 a,5 b,15 c from dual
union all
select 3 a,1 b,15 c from dual
union all
select 4 a,4 b,15 c from dual
union all
select 5 a,6 b,15 c from dual
union all
select 6 a,2 b,15 c from dual
union all
select 7 a,2 b,15 c from dual
union all
select 8 a,1 b,15 c from dual
)
select a,b,c,c - sum(b) over(order by a) d from temp
select 提货序号,
提货数,
库存数,
库存数-sum(提货数) over (order by 提货序号)
from tab;