SQL Server ROUND() Function

Round the number to 2 decimal places:

SELECT ROUND(235.415, 2) AS RoundValue;

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.

ROUND( number, decimals, operation)

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

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

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

SELECT ROUND(235.415, 2, 1) AS RoundValue;

Round the number to -1 decimal place:

SELECT ROUND(235.415, -1) AS RoundValue;