SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001

9-159

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

38986

50952

--- 5 row(s) selected.