Skip to main content
Version: current [24.3.x]

RANDOM

Categories: Math

RANDOM

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

Syntax

RANDOM([seed int32]) → double

  • seed (optional): Seed value. Specify a seed value to return a repeatable sequence of random numbers.

Examples

RANDOM example
SELECT RANDOM()
-- 0.24943567857336457
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.