最初由 一天到晚游泳d鱼 发布
[B]请教:如何取当前行与其前面所以行的合计
如:
A 5 3
B 6 9
C 1 4
D 2 8
结果:
A5 3
B11 12
C12 16
D14 24
谢谢! [/B]
SQL> select * from t;
STR ID1 ID2
--- --- ---
A 5 3
B 6 9
C 1 4
D 2 8
SQL>
SQL> SELECT a.str,SUM(a.id1) over(ORDER BY ROWNUM) id1,
2 SUM(a.id2) over(ORDER BY ROWNUM) id2
3 FROM t a
4/
STRID1ID2
--- ---------- ----------
A
5
3
B 11 12
C 12 16
D 14 24
SQL>