with t as (select 1 val from table union all select 5 from table) select val , sum(val) over( order by rownum rows between ubounded proceding and current row) from t group by rownum , val order by rownum;
转载于:https://my.oschina.net/wliming/blog/700306