Loading lesson path
Concept visual
Start at both ends
Round the number to 2 decimal places:
SELECT ROUND(235.415, 2) AS RoundValue;The ROUND() function rounds a number to a specified number of decimal places.
and
functions.
number, decimals, operation )
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.
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;Formula
Round the number to - 1 decimal place:SELECT ROUND(235.415, -1) AS RoundValue;❮ SQL Server Functions