RANDOM

All functions > METAPROGRAMMING > RANDOM

Returns a random number in the range 0.0 <= x < 1.0

Signatures

Returns: Random number in range [0.0, 1.0)

RANDOM() → DOUBLE

Notes

• Non-deterministic function - returns different values each call
• Returns uniformly distributed random numbers
• Range is [0.0, 1.0) - includes 0.0 but excludes 1.0
• Useful for sampling, simulations, and randomization
• Can be aliased as RAND()
• Warning: Results may vary between query executions
• Use with caution in cached or materialized queries

Aliases

• RAND