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-6
Sequence Functions
See the individual entry for the function.
Sequence Functions
Sequence functions operate on ordered rows of the intermediate result table of a
SELECT statement that includes a SEQUENCE BY clause. Sequence functions are
categorized generally as difference, moving, offset, or running.
FLOOR Function on
page 9-73
Returns the largest integer less than or equal to a numeric value
expression.
LOG Function
on
page 9-88
Returns the natural logarithm of a numeric value expression.
LOG10 Function
on
page 9-88
Returns the base 10 logarithm of a numeric value expression.
MOD Function
on
page 9-101
Returns the remainder (modulus) of an integer value expression
divided by an integer value expression.
PI Function
on
page 9-125
Returns the constant value of pi as a floating-point value.
POWER Function
on
page 9-127
Returns the value of a numeric value expression raised to the power
of an integer value expression. You can also use the exponential
operator **.
RADIANS Function
on page 9-138
Converts a numeric value expression expressed in degrees to the
number of radians.
SIGN Function
on
page 9-163
Returns an indicator of the sign of a numeric value expression. If
value is less than zero, returns -1 as the indicator. If value is zero,
returns 0. If value is greater than zero, returns 1.
SIN Function
on
page 9-164
Returns the sine of a numeric value expression, where the
expression is an angle expressed in radians.
SINH Function
on
page 9-164
Returns the hyperbolic sine of a numeric value expression, where
the expression is an angle expressed in radians.
SQRT Function
on
page 9-165
Returns the square root of a numeric value expression.
TAN Function
on
page 9-173
Returns the tangent of a numeric value expression, where the
expression is an angle expressed in radians.
TANH Function
on
page 9-173
Returns the hyperbolic tangent of a numeric value expression,
where the expression is an angle expressed in radians.
Difference sequence functions:
DIFF1 Function
on
page 9-54
Calculates differences between values of a column expression
in the current row and previous rows.
DIFF2 Function
on
page 9-57
Calculates differences between values of the result of DIFF1of
the current row and DIFF1 of previous rows.
Moving sequence functions: