randn
function
Applies to: Databricks SQL
Databricks Runtime
Returns a random value from a standard normal distribution.
Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
clause (TABLE)mask
clauseROW FILTER
clauseUpdated Feb 14, 2025
randn
function Applies to: Databricks SQL
Databricks Runtime
Returns a random value from a standard normal distribution.
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.
> SELECT randn();
-0.3254147983080288
> SELECT randn(0);
1.1164209726833079
> SELECT randn(null);
1.1164209726833079