random function

  • Article
  • 04/07/2025

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns a random value between 0 and 1. This function is a synonym for random function.

Syntax

random( [seed] )

Arguments

  • seed: An optional INTEGER literal.

Returns

A DOUBLE.

The function generates pseudo random results with independent and identically distributed uniformly distributed values in [0, 1).

This function is non-deterministic.

Examples

> SELECT rand();
 1.9629742951434543
> SELECT rand(0);
 1.8446490682263027
> SELECT rand(null);
 1.8446490682263027