1. SQL Reference Guide
  2. Built-in Functions
  3. Functions of Mathematical Operations
  4. random function

random function

The rand function returns a positive pseudo-random number. The resultant value can be greater than or equal to zero and less than one.

Syntax:

double rand()
Semantics:
  • The rand function does not expect any input arguments.
  • The rand function is evaluated for each row if used in a WHERE clause.
  • return type: double.

Example 12-88 random function

SELECT rand() AS RANDOM from Archery WHERE sim=1
Output:
 +-----------+-------------------+
 | RANDOM    | 0.891655403699787 |
 +-----------+-------------------+