Neoview SQL Reference Manual (R2.2)

Returns the number of nonnull values of a column
expression in the current window.
“MOVINGCOUNT Function” (page 368)
Returns the maximum of nonnull values of a column
expression in the current window.
“MOVINGMAX Function” (page 370)
Returns the minimum of nonnull values of a column
expression in the current window.
“MOVINGMIN Function” (page 371)
Returns the standard deviation of nonnull values of a
column expression in the current window.
“MOVINGSTDDEV Function” (page 372)
Returns the sum of nonnull values of a column expression
in the current window.
“MOVINGSUM Function” (page 374)
Returns the variance of nonnull values of a column
expression in the current window.
“MOVINGVARIANCE Function” (page 375)
Offset sequence function:
Retrieves columns from previous rows.“OFFSET Function” (page 381)
Running sequence functions:
Returns the rank of the given value of an intermediate
result table ordered by a SEQUENCE BY clause in a
SELECT statement
“RANK/RUNNINGRANK Function” (page 387)
Returns the average of nonnull values of a column
expression up to and including the current row.
“RUNNINGAVG Function” (page 395)
Returns the number of rows up to and including the
current row.
“RUNNINGCOUNT Function” (page 396)
Returns the maximum of values of a column expression
up to and including the current row.
“RUNNINGMAX Function” (page 397)
Returns the minimum of values of a column expression
up to and including the current row.
“RUNNINGMIN Function” (page 397)
Returns the rank of the given value of an intermediate
result table ordered by a SEQUENCE BY clause in a
SELECT statement.
“RUNNINGRANK Function” (page 399)
Returns the standard deviation of nonnull values of a
column expression up to and including the current row.
“RUNNINGSTDDEV Function” (page 400)
Returns the sum of nonnull values of a column expression
up to and including the current row.
“RUNNINGSUM Function” (page 401)
Returns the variance of nonnull values of a column
expression up to and including the current row.
“RUNNINGVARIANCE Function” (page 402)
Other sequence functions:
Returns the last nonnull value for the specified column
expression. If only null values have been returned, returns
null.
“LASTNOTNULL Function” (page 347)
Returns the number of rows counted since the specified
condition was last true.
“ROWS SINCE Function” (page 392)
Returns the number of rows counted since the specified
set of values last changed.
“ROWS SINCE CHANGED Function” (page 394)
Used in ROWS SINCE to distinguish between the value
of the column in the current row and the value of the
column in previous rows.
“THIS Function” (page 416)
See “SEQUENCE BY Clause” (page 268) and the individual entry for each function.
284 SQL Functions and Expressions