Returns a random number.

Syntax

---

RAND([RANGE <IntegerExpression>])
RAND([<IntegerExpression>])

<IntegerExpression> =

Type of:

SMALLINT
INTEGER|INT
BIGINT

Returns

---

FLOAT if no range specified
INTEGER equivalent to range if range specified

Usage

---

The RAND function returns a random number. The RANGE value is optional used to limit the random numbers returned to between 0 and the RANGE value specified. If the range is not specified then any number within the range of positive FLOAT values may be returned.

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: