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

The SQUARE function returns the square of the specified numeric value.

The SQUARE function returns the square of a numeric value in Azure Cosmos DB for NoSQL.

Syntax

SQUARE(<numeric_expr>)

Arguments

Return types

Returns a numeric expression.

Examples

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

Return squares of numbers

In this example, the SQUARE function is used to return the squares of various numbers.

SELECT VALUE {
  squareZero: SQUARE(0),
  squareOne: SQUARE(1),
  squareTwo: SQUARE(2),
  squareThree: SQUARE(3),
  squareNull: SQUARE(null)
}

[
  {
    "squareZero": 0,
    "squareOne": 1,
    "squareTwo": 4,
    "squareThree": 9
  }
]

Remarks

• This function doesn't utilize the index.