Numbers & math
Scalar
abs()
Absolute value
Reference: DuckDB 2.0.0
Alias of @
Arguments & returns
13 overloadsabs(x)
Scalar
Example
Haybarn WASM 2.0.0-rc12 ยท 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)
SELECT (CASE WHEN 10 > 0 THEN 10 - 1 ELSE ABS(10) END) % 32768