RAND

Returns a pseudo-random float value from 0 through 1, exclusive.

Syntax

RAND ( [ seed ] )

Arguments

seed

Is an integer expression (tinyint, smallint, or int) that gives the seed value. If seed is not specified, Querona assigns a seed value at random. For a specified seed value, the result returned is always the same.

Return types

float

Examples

SELECT RAND(100), RAND(), RAND();

See Also