randn function

Applies to: Databricks SQL Databricks Runtime

Returns a random value from a standard normal distribution.

Syntax

randn( [seed] )

Arguments

• seed: An optional INTEGER 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

SQL

> SELECT randn();
 -0.3254147983080288
> SELECT randn(0);
 1.1164209726833079
> SELECT randn(null);
 1.1164209726833079

Related functions

• rand function
• randstr function
• random function
• uniform function