On this page

    Categories: Data Generation

    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.