ABS

Returns the positive value of a given number, regardless of sign.

Syntax

ABS ( expression )

Arguments

  • expression: any expression. This may be a column name, the result of another function, or a math operation.

Return Type

The absolute value of the expression.

Examples

SELECT ABS(-9);
+---------+
| ABS(-9) |
+---------+
|       9 |
+---------+
SELECT ABS(9);
+--------+
| ABS(9) |
+--------+
|      9 |
+--------+
SELECT ABS(20-50);
+------------+
| ABS(20-50) |
+------------+
|         30 |
+------------+

Last modified: April 17, 2023

Was this article helpful?