Neoview SQL Reference Manual (R2.5)

RUNNINGMIN Function

The RUNNINGMIN function is a sequence function that returns the minimum of values of a

column up to and including the current row of an intermediate result table ordered by a

SEQUENCE BY clause in a SELECT statement. See “SEQUENCE BY Clause” (page 326).

RUNNINGMIN is a Neoview SQL extension.

RUNNINGMIN (column-expression)

column-expression

specifies a derived column determined by the evaluation of the column expression.

RUNNINGMIN returns the minimum of values of column-expression up to and including

the current row.

Example 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.

RUNNINGRANK Function

See the “RANK/RUNNINGRANK Function” (page 444).

RUNNINGMIN Function 459