SQL ABS Function

The SQL ABS function is one of the SQL Mathematical Function which will return the absolute (Positive) value of the specified expression.

SQL ABS Function Syntax

The basic syntax of the SQL Server ABS Function is:

In this article we will show you, How to write ABS Function in SQL Server 2014 with example. For this, We are going to use the below shown data

SQL ABS Function Example 1

The SQL Server ABS Function is used to return the positive value of any numeric value. The following query will show multiple ways to use ABS function.

T-SQL CODE

OUTPUT

ANALYSIS

Below lines of code is used to declare Int variable and assigning the value.

In the below statement, We used ABS function to find the absolute value of the variable @i (It means ABS(-25.8)). We also assigned new name to that result as ‘Absolute Value’ using ALIAS Column.

In the next statement, We used the ABS Function directly on the int value.

In the below statement, We used the ABS Function directly on the multiple values.

It means

ABS(2 + 55 – 77)

ABS (-20) = 20

SQL ABS Function Example 2

ABS Function also allows you to find the absolute values of a column values.  In this example, We are going to find the absolute values for all the records present in [Service Grade] using ABS Function.

T-SQL CODE

OUTPUT

Thank You for Visiting Our Blog