SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
9-7
Sequence Functions
MOVINGAVG Function on
page 9-104
Returns the average of nonnull values of a column expression
in the current window.
MOVINGCOUNT
Function on page 9-106
Returns the number of nonnull values of a column expression
in the current window.
MOVINGMAX Function
on page 9-108
Returns the maximum of nonnull values of a column expression
in the current window.
MOVINGMIN Function
on
page 9-110
Returns the minimum of nonnull values of a column expression
in the current window.
MOVINGSTDDEV
Function on page 9-112
Returns the standard deviation of nonnull values of a column
expression in the current window.
MOVINGSUM Function
on page 9-114
Returns the sum of nonnull values of a column expression in
the current window.
MOVINGVARIANCE
Function on page 9-116
Returns the variance of nonnull values of a column expression
in the current window.
Offset sequence function:
OFFSET Function
on
page 9-123
Retrieves columns from previous rows.
Running sequence functions:
RUNNINGAVG Function
on page 9-148
Returns the average of nonnull values of a column expression
up to and including the current row.
RUNNINGCOUNT
Function on page 9-150
Returns the number of rows up to and including the current row.
RUNNINGMAX Function
on page 9-152
Returns the maximum of values of a column expression up to
and including the current row.
RUNNINGMIN Function
on page 9-154
Returns the minimum of values of a column expression up to
and including the current row.
RUNNINGSTDDEV
Function on page 9-156
Returns the standard deviation of nonnull values of a column
expression up to and including the current row.
RUNNINGSUM Function
on page 9-158
Returns the sum of nonnull values of a column expression up to
and including the current row.
RUNNINGVARIANCE
Function on page 9-160
Returns the variance of nonnull values of a column expression
up to and including the current row.
Other sequence functions: