SQL Server ROUND() Function

The SQL Server (Transact-SQL) ROUND() function returns a number rounded to the specified number of decimal places. If decimal_places is a negative number, this function will make digits to the left of the decimal place 0 values.

Syntax

ROUND(number, decimal_places, operation)

Parameters

Return Value

Returns the rounded value of the number to specified decimal_places.

Example 1:

The example below shows the usage of ROUND() function.

SELECT ROUND(1234.5678, 0);
Result: 1235.0000

SELECT ROUND(1234.5678, 1);
Result: 1234.6000

SELECT ROUND(1234.5678, 2);
Result: 1234.5700

SELECT ROUND(1234.5678, 3);
Result: 1234.5680

SELECT ROUND(1234.5678, -1);
Result: 1230.0000

SELECT ROUND(1234.5678, -2);
Result: 1200.0000

SELECT ROUND(1234.5678, 2, 0);
Result: 1234.5700

--using round() function to truncate
SELECT ROUND(1234.5678, 2, 1);
Result: 1234.5600

Example 2:

Consider a database table called Sample with the following records:

The statement given below can be used to round the records of column x to 2 decimal places.

SELECT *, ROUND(x, 2) AS ROUND_Value FROM Sample;

This will produce the result as shown below: