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

SQL/MX Functions and Expressions

HP NonStop SQL/MX Reference Manual—523725-004

9-133

Examples of RUNNINGMIN

•

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

SELECT RUNNINGMIN (I1) AS MIN_I1

FROM mining.seqfcn

SEQUENCE BY TS;

MIN_I1

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

6215

4597

--- 5 row(s) selected.