SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
9-154
Examples of RUNNINGAVG

Return the average of non-null 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.