with t as ( select 16 a from dual union all select 18 from dual union all select 19 from dual ) select a, sum(a)over(partition by 1 order by a) b from t
with t as ( select 16 a from dual union all select 18 from dual union all select 19 from dual ) select a, sum(a)over(partition by 1 order by a) b from t --直接运行,结果如下: 16 16 18 34 19 53
select getintegral,sum(getintegral)over(order by rownum rows between unbounded preceding and current row)RemainIntegral from table1 这个例子里,按rownum排序的话,可以不用加rows bet... 但是如果排序的对象值重复的话,可能会出错
18 34
15 49不好意思图片没显示出来!
如上面我写的
我要得到的是 很多条记录 而不是一条
没条记录的 getintegral RemainIntegral
的值 如上面我所说的
as
(
select 16 a from dual
union all
select 18 from dual
union all
select 19 from dual
)
select a, sum(a)over(partition by 1 order by a) b from t
with t
as
(
select 16 a from dual
union all
select 18 from dual
union all
select 19 from dual
)
select a, sum(a)over(partition by 1 order by a) b from t
--直接运行,结果如下:
16 16
18 34
19 53
select getintegral,sum(getintegral)over(order by rownum rows between unbounded preceding and current row)RemainIntegral from table1
这个例子里,按rownum排序的话,可以不用加rows bet...
但是如果排序的对象值重复的话,可能会出错