ROUND: Rounds a value to the number of decimal places specified in the second parameter : ROUND « Math Functions « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Math Functions
  3. ROUND

ROUND: Rounds a value to the number of decimal places specified in the second parameter



2> -- ROUND: Rounds a value to the number of decimal places specified in the second parameter.
3>
4> -- ROUND(number_to_round, number_ of_places,[0|1])
5>
6> SELECT ROUND(100.345678,5,0)
7> GO

-----------
 100.345680

(1 rows affected)








Related examples in the same category

1.Round the updated data
2.ROUND(107.345678,-1,0)
3.ROUND(100.345678,5,1)
4.select ROUND(12.5,0)
5.select ROUND(12.4999,0)
6.select ROUND(12.4999,1)
7.select ROUND(12.4999,-1) (minus)
8.select ROUND(12.5,0,1)