RANDOM function
Derby Reference Manual
136
The data type of the returned value is a
Syntax
PI ( )
RADIANS function
The RADIANS function converts a specified number from degrees to radians.
The specified number is an angle measured in degrees, which is converted to an
approximately equivalent angle measured in radians. The specified number must be a
number.
Attention: The conversion from degrees to radians is not exact.
The data type of the returned value is a DOUBLE PRECISION number.
Syntax
RADIANS ( number )
RANDOM function
The RANDOM function returns a random number.
The RANDOM function returns a
number with positive sign,
greater than or equal to zero (0), and less than one (1.0).
Syntax
RANDOM()
RAND function
The RAND function returns a random number given a seed number
The RAND function returns a
number with positive sign, greater
than or equal to zero (0), and less than one (1.0), given an
Syntax
RAND( seed )
ROW_NUMBER function
The ROW_NUMBER function returns the row number over a named or unnamed window
specification.
The ROW_NUMBER function does not take any arguments, and for each row over the
window it returns an ever increasing BIGINT. It is normally used to limit the number of
rows returned for a query. The LIMIT keyword used in other databases is not defined in
the SQL standard, and is not supported.
· Derby does not currently allow the named or unnamed window specification to be
specified in the
OVER()
clause, but requires an empty parenthesis. This means the
function is evaluated over the entire result set.
· The ROW_NUMBER function cannot currently be used in a WHERE clause.
· Derby does not currently support ORDER BY in subqueries, so there is currently no
way to guarantee the order of rows in the SELECT subquery. An optimizer override
