ABS

Returns the absolute value of a numeric expression.

Syntax

ABS(expr)

Example

SELECT NULL as my_column,  abs(NULL) as abs_value
UNION ALL 
SELECT 0.0 as my_column,  abs(0.0) as abs_value
UNION ALL 
SELECT 1.1 as my_column, abs(1.1) as abs_value
UNION ALL 
SELECT -7.3 as my_column, abs(-7.3) as abs_value
UNION ALL 
SELECT 4.9 as my_column,  abs(4.9) as abs_value
UNION ALL 
SELECT -19.1 as my_column, abs(-19.1) as abs_value

+-----------+-----------+
| MY_COLUMN | ABS_VALUE |
+-----------+-----------+
| NULL      | NULL      |
|         0 |         0 |
|       1.1 |       1.1 |
|      -7.3 |       7.3 |
|       4.9 |       4.9 |
|     -19.1 |      19.1 |
+-----------+-----------+