Functions/Numbers & math/abs
Numbers & math Scalar

abs()

Absolute value

Alias of @

Arguments & returns

13 overloads

abs(x)

Scalar
Overload link x Returns
#01 BIGINT BIGINT
#02 DECIMAL DECIMAL
#03 DOUBLE DOUBLE
#04 FLOAT FLOAT
#05 HUGEINT HUGEINT
#06 INTEGER INTEGER
#07 SMALLINT SMALLINT
#08 TINYINT TINYINT
#09 UBIGINT UBIGINT
#10 UHUGEINT UHUGEINT
#11 UINTEGER UINTEGER
#12 USMALLINT USMALLINT
#13 UTINYINT UTINYINT

Example

abs example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Used in larger rewrites 1

These examples use abs as one part of a larger SQL translation.

Snowflakebitmap_bit_position()

SELECT BITMAP_BIT_POSITION(10)
In DuckDB
SELECT (CASE WHEN 10 > 0 THEN 10 - 1 ELSE ABS(10) END) % 32768

SQLGlot example ↗