ABS

7min

Overview
The ABS() function returns the absolute value of a number.
The input and return types we support can be seen in the table below.
﻿
✅ The ABS() function returns a value that is the same as the input types.
Examples
#Case 1: Basic Absolute
The following example will calculate the absolute value of a negative floating number:
Select abs
|
SELECT ABS(-22.50) AS "Absolute";
SELECT ABS(-22.50) AS "Absolute";
﻿
It will return the floating number without the negative value:
Output
|
+-----------+
| Absolute  |
+-----------+
| 22.50     |
+-----------+
+-----------+
| Absolute  |
+-----------+
| 22.50     |
+-----------+
﻿
#Case 2: Absolute with an expression
The following example calculates the absolute value of an expression i.e., the subtraction operation:
Select abs
|
SELECT ABS( 150 - 250 ) AS "Absolute";
SELECT ABS( 150 - 250 ) AS "Absolute";
﻿
We know that the result of (150 - 250) is -100, but in this case, we’re using an ABS() function to get an absolute number so that the result will ignore the negative value.
Output
|
+-----------+
| Absolute  |
+-----------+
| 100       |
+-----------+
+-----------+
| Absolute  |
+-----------+
| 100       |
+-----------+
﻿
﻿

Updated 31 Aug 2023

Did this page help you?

TABLE OF CONTENTS

Overview

Examples

#Case 1: Basic Absolute

#Case 2: Absolute with an expression