ABS

Calculates the absolute value of a number <value>, displaying the number’s distance from 0.

Syntax

ABS(<value>)

Parameter	Description	Supported input types
`<numeric_type>`	The number that the absolute value function is applied to.	Any `NUMERIC` type

NUMERIC

The following example returns the absolute value of -200.5:

SELECT ABS(-200.50) as result;

result double
200.5

Rows: 1Execution time: 5.66ms

⌘I