# SQL ABS() Function

The SQL ABS() is a function, and return absolute value of a given number from query result.

The SQL ABS() function remove the positive(+) or negative(-) sign symbol from the given input number.

Ex:

• Abs(5) = result is "5"
• Abs(5.77) = result is "5.77"
• Abs(5.12) = result is "5.12"
• Abs(+5) = result is "5"
• Abs(-5) = result is "5"

The SQL ABS() function is supports only numeric column or an numeric field based expression.

It can be used in SELECT statement as well in where clause.

## SQL ABS() Syntax

The below syntax is used to select a absolute value from a given number or expression without a table.

``````
SELECT ABS(number);

``````

The below syntax is used to select a absolute value from a given table numeric column or field from a specific table.

``````
SELECT ABS(Column_name) FROM table_name;

``````

### Search Keys

• sql abs function
• absolute value sql
• sql server absolute value
• mathematical operators
• sql format number
• sql decimal format

## SQL ABS() Example - Using Expression Or Formula

The following SQL SELECT statement returns the absolute value of a given input number or expression

``````
SELECT Abs(-13) AS 'Absolute Value';

``````

The result of above query is:

Absolute Value
13

### SQL ABS() Function More Example

Input Value Result
Abs(5) 5
Abs(+6) 6
Abs(-7) 7
Abs(2.34) 2.34
Abs(-1.6) 1.6

## Sample Database Table - Customer

CID CName Balance City
111 Suresh Babu 128.66 Nasik
222 Suresh Kumar -55.23 Nasik
333 Vinoth Kumar -233.85 Chennai
555 Haris Karthik 673.88 Bangalore
666 Kishor Kumar -188.63 Chennai

## SQL ABS() Example - With Table Column

The following SQL SELECT statement find the absolute value of a given table column "Balance" from the "Customer" table:

``````
SELECT
ABS(Balance) As 'Absolute Balance Value'
FROM Customer;

``````

The result of above query is:

Absolute Balance Value
128.66
55.23
233.85
560
673.88
188.63

## SQL ABS() Example - Using WHERE Clause

The following SQL SELECT statement find the absolute value of a given input number for creating condition (greater than the given value) on table column "Balance" from the "Customer" table:

``````
SELECT * FROM Customer
WHERE Balance > ABS(-200);

``````

The result of above query is:

CID CName Balance City
555 Haris Karthik 673.88 Bangalore

Note: The Abs(-200) function will return a value of "200". So now the result set contains and display records or rows which has balance more than "200" on column "Balance" from the "Customer" table.

### Search Keys

• sql server format number
• sql numeric functions
• abs sql
• absolute value oracle
• sql function abs
• abs function sql