时间段是11:30,当前数量是0的时候,累积求和函数sum() over()没时间累积效果,请问当前值是0时如何实现累积统计的效果
时间段 当前数据段数量 累积求和 [sum(sl) over(order by groupid asc)]
9:30 5 5
10:30 6 11
11:30 0 0 (ps:这里应该是11+0=11)
12:30 2 13
不会的,这样是可以的呀
with a as (
select '09:05:00' as 时间,5 as 数量 from dual
union all
select '10:05:00' as 时间,6 as 数量 from dual
select '11:05:00' as 时间,0 as 数量 from dual
select '12:05:00' as 时间,8 as 数量 from dual
)
select
时间,
SUM(数量) OVER (ORDER BY 时间) AS running_total ,
数量
from a
-------------------------------