Categories: Data Generation
Each call returns a random generated number between 0 and 1 for each row.
RANDOM() → double
SELECT RANDOM() -- 0.24943567857336457
RANDOM(seed int32) → double
- seed: Seed value.
SELECT RANDOM(4000) -- 0.18633151868393985
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.
Was this page helpful?
Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.