ABS
On this page
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