Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

ABS

Example

Retrieve the absolute value of a numeric expression.

SELECT Abs(-243.5AS AbsNum;

Definition and Usage

The ABS() function calculates and returns the absolute value of a number.

Syntax

ABS(number)

Parameter Values

Parameter

Description

number

Required. A numerical value that the function will operate on.

Technical Details

Works in:

Available in SQL Server from 2008 onward, as well as in Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse.