RANDOM

Categories: Data Generation

RANDOM

Each call returns a random generated number between 0 and 1 for each row.

Syntax

RANDOM() → double

Examples

{{< codeheader "RANDOM example" >}}

SELECT RANDOM()
-- 0.24943567857336457

RANDOM([seed int32]) → double

• seed (optional): Seed value.

Examples

{{< codeheader "RANDOM example" >}}

SELECT RANDOM(4000)
-- 0.18633151868393985

Usage Notes

If a seed value is specified, RANDOM generates a unique number for each row. If the same seed is used to call RANDOM on the same row multiple times, the same generated number will be returned each time.