RAND()
Learn how to use the RAND() numeric function in PlaidCloud Lakehouse. Returns a random floating-point value v in the range 0 <= v < 1. With syntax and examples.
Returns a random floating-point value v in the range 0 <= v < 1.0. To obtain a random integer R in the range i <= R < j, use the expression FLOOR(i + RAND() * (j − i)).
Analyze Syntax
func.rand()
Analyze Examples
func.rand()
┌────────────────────┐
│ func.rand() │
├────────────────────┤
│ 0.5191511074382174 │
└────────────────────┘
SQL Syntax
RAND()
SQL Examples
SELECT RAND();
┌────────────────────┐
│ rand() │
├────────────────────┤
│ 0.5191511074382174 │
└────────────────────┘