Link Search Menu Expand Document

ABS

Calculates the absolute value of a number <value>. This means displaying the number’s distance from 0.

Syntax

ABS(<value>)

Parameters

Parameter Description Supported input types
<numeric_type> The number that the absolute value function is applied to. Any NUMERIC type

Return Type

NUMERIC

Example

The following example returns the absolute value of -200.5:

SELECT
    ABS(-200.50);

Returns: 200.5