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 | +------------+