Neoview SQL Reference Manual (R2.4 SP2)

such operations may not be parallelized because the entire sorted result set must be available in
order to compute the result of the sequence function.
Difference sequence functions:
Calculates differences between values of a column
expression in the current row and previous rows.
“DIFF1 Function” (page 384)
Calculates differences between values of the result of
DIFF1 of the current row and DIFF1 of previous rows.
“DIFF2 Function” (page 386)
Moving sequence functions:
Returns the average of nonnull values of a column
expression in the current window.
“MOVINGAVG Function” (page 413)
Returns the number of nonnull values of a column
expression in the current window.
“MOVINGCOUNT Function” (page 414)
Returns the maximum of nonnull values of a column
expression in the current window.
“MOVINGMAX Function” (page 415)
Returns the minimum of nonnull values of a column
expression in the current window.
“MOVINGMIN Function” (page 416)
Returns the standard deviation of nonnull values of a
column expression in the current window.
“MOVINGSTDDEV Function” (page 417)
Returns the sum of nonnull values of a column expression
in the current window.
“MOVINGSUM Function” (page 419)
Returns the variance of nonnull values of a column
expression in the current window.
“MOVINGVARIANCE Function” (page 420)
Offset sequence function:
Retrieves columns from previous rows.“OFFSET Function” (page 426)
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 432)
Returns the average of nonnull values of a column
expression up to and including the current row.
“RUNNINGAVG Function” (page 444)
Returns the number of rows up to and including the
current row.
“RUNNINGCOUNT Function” (page 445)
Returns the maximum of values of a column expression
up to and including the current row.
“RUNNINGMAX Function” (page 446)
Returns the minimum of values of a column expression
up to and including the current row.
“RUNNINGMIN Function” (page 447)
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 447)
Returns the standard deviation of nonnull values of a
column expression up to and including the current row.
“RUNNINGSTDDEV Function” (page 448)
Returns the sum of nonnull values of a column expression
up to and including the current row.
“RUNNINGSUM Function” (page 449)
Returns the variance of nonnull values of a column
expression up to and including the current row.
“RUNNINGVARIANCE Function” (page 450)
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 398)
Returns the number of rows counted since the specified
condition was last true.
“ROWS SINCE Function” (page 439)
330 SQL Functions and Expressions