ABS function [Numeric]

Function

Returns the absolute value of a numeric expression.

Syntax

ABS ( numeric-expression )

Parameters

numeric-expression The number whose absolute value is to be returned.

Example

The following statement returns the value 66.

SELECT ABS( -66 ) FROM iq_dummy

Standards and compatibility