Neoview SQL Reference Manual (R2.4 SP2)

Converts a numeric value expression expressed in radians
to the number of degrees.
“DEGREES Function” (page 383)
Returns the exponential value (to the base e) of a numeric
value expression.
“EXP Function” (page 388)
Returns the largest integer less than or equal to a numeric
value expression.
“FLOOR Function” (page 393)
Returns the natural logarithm of a numeric value
expression.
“LOG Function” (page 402)
Returns the base 10 logarithm of a numeric value
expression.
“LOG10 Function” (page 403)
Returns the remainder (modulus) of an integer value
expression divided by an integer value expression.
“MOD Function” (page 410)
Returns the value of the operand unless it is zero, in which
case it returns NULL.
“NULLIFZERO Function” (page 423)
Returns the constant value of pi as a floating-point value.“PI Function” (page 427)
Returns the value of a numeric value expression raised to
the power of an integer value expression. You can also
use the exponential operator **.
“POWER Function” (page 429)
Converts a numeric value expression expressed in degrees
to the number of radians.
“RADIANS Function” (page 431)
Returns the value of numeric_expr round to num places
to the right of the decimal point.
“ROUND Function” (page 438)
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.
“SIGN Function” (page 452)
Returns the sine of a numeric value expression, where the
expression is an angle expressed in radians.
“SIN Function” (page 453)
Returns the hyperbolic sine of a numeric value expression,
where the expression is an angle expressed in radians.
“SINH Function” (page 454)
Returns the square root of a numeric value expression.“SQRT Function” (page 456)
Returns the tangent of a numeric value expression, where
the expression is an angle expressed in radians.
“TAN Function” (page 462)
Returns the hyperbolic tangent of a numeric value
expression, where the expression is an angle expressed in
radians.
“TANH Function” (page 463)
Returns the value of the operand unless it is NULL, in
which case it returns zero.
“ZEROIFNULL Function” (page 477)
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.
Some sequence functions, such as ROWS SINCE, require sequentially examining every row in
the history buffer until the result is computed. Examining a large history buffer in this manner
for a condition that has not been true for many rows could be an expensive operation. In addition,
Categories 329