ROUND() Function in Sql Server

Introduction:

The ROUND() function is used to round a numeric field to the number of decimals specified.

 

Syntax:

SELECT ROUND(column_name,decimals) FROM table_name;

Example:

SELECT ProductName, ROUND(Price,0) AS RoundedPrice
FROM product_tb;