Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: Databricks SQL
Databricks Runtime
Returns a random value from a standard normal distribution.
Syntax
randn( [seed] )
Arguments
seed
: An optionalINTEGER
literal.
Returns
A DOUBLE
.
The function regenerates pseudo random results with independent and identically distributed (i.i.d.) values drawn from the standard normal distribution.
This function is non-deterministic.
Examples
> SELECT randn();
-0.3254147983080288
> SELECT randn(0);
1.1164209726833079
> SELECT randn(null);
1.1164209726833079