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

The INTDIV function returns the result of dividing the first integer value by the second.

Syntax

INTDIV(<numeric_expr_1>, <numeric_expr_2>)

Arguments

	Description
numeric_expr_1	The numerator numeric expression.
numeric_expr_2	The denominator numeric expression.

Return types

Returns a numeric expression.

Examples

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

Divide integer values

In this example, the INTDIV function is used to divide two numbers.

SELECT VALUE {
  divide: INTDIV(10, 2),
  negativeResult: INTDIV(10, -2),
  positiveResult: INTDIV(-10, -2),
  resultOne: INTDIV(10, 10),
  divideZero: INTDIV(10, 0),
  divideDecimal: INTDIV(10, 0.1)
}

[
  {
    "divide": 5,
    "negativeResult": -5,
    "positiveResult": 5,
    "resultOne": 1
  }
]