abs({n})

Returns the absolute number of n as a numeric value. n can be any real numeric value in the range of -1.797e308 <= n <= 1.797e308.

abs({n}) takes the following syntax.

SELECT abs(COLUMN_NAME) as ALIASNAME
FROM DATASET;

Example

This example takes the absolute value of the Profit field.

SELECT abs(Profit) as absProfit FROM Superstore
LIMIT 1;