Edit

Share via

RAND (NoSQL query)

  • Applies to: Azure Cosmos DB for NoSQL, Cosmos DB in 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
  }
]