ABS (NoSQL query)

  • Article

APPLIES TO: NoSQL

Returns the absolute (positive) value of the specified numeric expression.

Syntax

ABS(<numeric_expr>)

Arguments

Description
numeric_expr A numeric expression.

Return types

Returns a numeric expression.

Examples

The following example shows the results of using this function on three different numbers.

SELECT VALUE { 
    absoluteNegativeOne: ABS(-1),
    absoluteZero: ABS(0),
    absoluteOne: ABS(1) 
}

[
  {
    "absoluteNegativeOne": 1,
    "absoluteZero": 0,
    "absoluteOne": 1
  }
]

Remarks

  • This function benefits from the use of a range index.

Related content