SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
9-127
Examples of RUNNINGAVG
•
Return the average of nonnull values of I1 up to and including the current row:
SELECT RUNNINGAVG (I1) AS AVG_I1
FROM mining.seqfcn
SEQUENCE BY TS;
AVG_I1
--------------------
6215
17194
11463
9746
10190
--- 5 row(s) selected.