RANDOM
All functions > MATH > RANDOM
[Non-deterministic] Returns a random number in the range 0.0 <= x < 1.0
Syntax
RANDOM(bound1, bound2)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
bound1 | ANY | Yes | |
bound2 | ANY | Yes |
Returns
DOUBLE - Random number in range [0.0, 1.0)
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