In this article, I will explore one of the SQL Server mathematical functions, ROUND. The T-SQL ROUND() function rounds off a numeric value to a specified length or precision. The syntax to use this function is given below:
ROUND ( numeric_value , length )
The parameters are:
Numeric_value is the number for which we need to get a rounded value. Length is the precision to which the value will be rounded. If you specify a positive number, the function will round after decimal values, and if you specify a negative value, the function will round before the decimal value.