แชร์ผ่าน

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

  • นำไปใช้กับ: ✅ Azure Cosmos DB, ✅ Cosmos DB in Microsoft Fabric

The INTMUL function returns the product of two integer values.

Syntax

INTMUL(<numeric_expr_1>, <numeric_expr_2>)

Arguments

Description
numeric_expr_1 The first numeric expression.
numeric_expr_2 The second numeric expression.

Return types

Returns a numeric expression.

Examples

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

Multiply integer values

In this example, the INTMUL function is used to multiply two numbers.

SELECT VALUE {
  multiply: INTMUL(5, 2),
  negativeResult: INTMUL(5, -2),
  positiveResult: INTMUL(-5, -2),
  square: INTMUL(5, 5),
  cube: INTMUL(5, INTMUL(5, 5)),
  multiplyZero: INTMUL(5, 0),
  multiplyDecimal: INTMUL(5, 0.5)
}

[
  {
    "multiply": 10,
    "negativeResult": -10,
    "positiveResult": 10,
    "square": 25,
    "cube": 125,
    "multiplyZero": 0
  }
]
  • Last updated on