RAND - Query language in Cosmos DB (in Azure and Fabric)

The RAND function returns a randomly generated numeric value from zero to one.

Syntax

RAND()

Return types

Returns a numeric expression.

Examples

This section contains examples of how to use this query language construct.

Randomly generated values

In this example, the RAND function is used to return random values.

SELECT VALUE {
  randomOneToOne: RAND(),
  randomeOneToHundred: RAND() * 100
}

[
  {
    "randomOneToOne": 0.134644033620134,
    "randomeOneToHundred": 57.51777137629688
  }
]