The SQL ABS function is a Mathematical Function that will return the absolute positive value of the specified expression. The syntax of the SQL Server ABS Function to find absolute value is:
SELECT ABS (Numeric_Expression) FROM [Source]
For this SQL Server ABS function demo, we use the below-shown data
SQL ABS Function Example 1
The SQL Server ABS Function returns the absolute positive value of any numeric value. The following Mathematical Function query will show multiple ways to use the ABS function.
-- Sql Server Absolute Value DECLARE @i int SET @i = -25.8 SELECT ABS(@i) AS [Absolute Value] -- Calculating ABS directly SELECT ABS(-27) AS [Absolute Value] -- Calculating ABS directly SELECT ABS(2 + 55 - 77) AS [Absolute Value]
OUTPUT
ANALYSIS
We used the ABS function to find the absolute value of the variable @i. It means ABS(-25.8) and assigned a new name ‘Absolute Value’ using the ALIAS Column.
SELECT ABS(@i) AS [Absolute Value]
In the next SQL Server statement, We used the absolute directly on the int value.
SELECT ABS(-27) AS [Absolute Value]
In the below statement, We used the ABS Function directly on the multiple values.
SELECT ABS(2 + 55 - 77) AS [Absolute Value]
It means
ABS(2 + 55 – 77)
ABS (-20) = 20
ABS Function Example 2
The ABS Function also allows you to find the absolute values of a column values. Here, we are going to find the absolute values for all the records present in [Service Grade] using this ABS Function.
-- SQL Absolute Value SELECT [EnglishProductName] ,[Color] ,[StandardCost] ,[SalesAmount] ,[Service Grade] ,ABS([Service Grade]) AS [Absolute Value] FROM [Mathemetical Functions]
OUTPUT