SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004

8-158

Examples of RUNNINGMAX

•

Return the maximum of values of I1 up to and including the current row:

SELECT RUNNINGMAX (I1) AS MAX_I1

FROM mining.seqfcn

SEQUENCE BY TS;

MAX_I1

------------

6215

28174

--- 5 row(s) selected.