THE WORLD'S LARGEST WEB DEVELOPER SITE

SQL Server ROUND() Function

❮ SQL Server Functions

Example

Round the number to 2 decimal places:

SELECT ROUND(235.415, 2) AS RoundValue;
Try it Yourself »

Definition and Usage

The ROUND() function rounds a number to a specified number of decimal places.

Tip: Also look at the FLOOR() and CEILING() functions.

Syntax

ROUND(number, decimals, operation)

Parameter Values

Parameter Description
number Required. The number to be rounded
decimals Required. The number of decimal places to round number to
operation Optional. If 0, it rounds the result to the number of decimal. If another value than 0, it truncates the result to the number of decimals. Default value is 0

Technical Details

Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

More Examples

Example

Round the number to 2 decimal places, and also use the operation parameter:

SELECT ROUND(235.415, 2, 1) AS RoundValue;
Try it Yourself »

Example

Round the number to -1 decimal place:

SELECT ROUND(235.415, -1) AS RoundValue;
Try it Yourself »

❮ SQL Server Functions