create table test ( A number(5) ) insert into test values(1); insert into test values(2); insert into test values(3); insert into test values(4); commit ----------------- select A,sum(A)over(order by A) as A_sum from test;得到的结果集为 A A_sum 1 1 2 3 3 6 4 10drop table test --------------------- 这样统计后的结果集要重新计算
(
A number(5)
)
insert into test values(1);
insert into test values(2);
insert into test values(3);
insert into test values(4);
commit
-----------------
select A,sum(A)over(order by A) as A_sum from test;得到的结果集为
A A_sum
1 1
2 3
3 6
4 10drop table test
---------------------
这样统计后的结果集要重新计算