RANDOM
Each call returns a random generated number between 0 and 1 for each row.
Syntax
RANDOM() → double
Examples
SELECT RANDOM()
-- 0.24943567857336457
RANDOM(seed int32) → double
seed: Seed value.
Examples
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.
Last updated
Was this helpful?