Skip to main content
Returns a pseudo-random unsigned value greater than 0 and less than 1 of type DOUBLE PRECISION.

​
Syntax

RANDOM()

​
Return Types

DOUBLE PRECISION

​
Examples

The following code example demonstrates using RANDOM without any other numeric functions. This generates a DOUBLE PRECISION value less than 1: 
SELECT RANDOM()
random double
0.6527596650249162

Rows: 1Execution time: 5.09ms

To create a random integer number between two values, you can use RANDOM with the FLOOR function. If a is the lesser value and b is the greater value, compute FLOOR(RANDOM() * (b - a + 1)) + a. The following code example generates a random integer between 50 and 100: 
SELECT FLOOR(RANDOM() * (100 - 50 + 1)) + 50
?column? double
67

Rows: 1Execution time: 5.51ms