ABS(X) returns the absolute value of X. : ABS « Math Numeric Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. ABS
mysql>
mysql> SELECT ABS(2);
+--------+
| ABS(2) |
+--------+
|      2 |
+--------+
1 row in set (0.00 sec)

mysql> SELECT ABS(-32);
+----------+
| ABS(-32) |
+----------+
|       32 |
+----------+
1 row in set (0.00 sec)

mysql>








21.3.ABS
21.3.1.ABS(X) returns the absolute value of X.
21.3.2.Get the absolute value for a column