RAND

The RAND function returns a random number given a seed number

The RAND function returns a DOUBLE PRECISION number with positive sign, greater than or equal to zero (0), and less than one (1.0), given an INTEGER seed number.

Syntax

RAND( seed )