login

SQL ABS Function

SQL ABS function returns the absolute value of an numeric input argument. Here is the syntax:

ABS(<numeric expression>)

Here is an example query:

SELECT ABS(-10) as arg1,
       ABS(10) AS arg2

and the output is

  arg1  arg2  
------  ------
    10      10
Read On