SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-135
Examples of RUNNINGSUM
•
Return the sum of nonnull values of I1 up to and including the current row:
SELECT RUNNINGSUM (I1) AS SUM_I1
FROM mining.seqfcn
SEQUENCE BY TS;
SUM_I1
--------------------
6215
34389
34389
38986
50952
--- 5 row(s) selected.