Native cloud deployment on Azure is not available for this version of Exasol, but you can install Exasol as a Linux application on Azure instances. For more information, see Installation.

Native cloud deployment on Google Cloud is not available for this version of Exasol, but you can install Exasol as a Linux application on Google Cloud instances. For more information, see Installation.

RAND[OM]

Purpose

This function generates a random number.

Syntax

random::=

Random

Usage Notes

The result is always a DOUBLE.
When specifying the optional parameters, a random number within the interval [min,max] is created. Without any parameters this interval is [0,1].

Example

Copy

SELECT RANDOM() RANDOM_1, RANDOM(5,20) RANDOM_2;

Result

RANDOM_1	RANDOM_2
0.379277567626116	12.7548096816858