Explain ROUND () function in SQL Server.

The ROUND () function is used for rounding the numeric value to the number of decimals required.

Ex :

Select EmployeeName, round (EmployeeReimbursement, 0)

as EmployeeReimbursement

from Employees

This Query will display the Employee Name and the Employee Reimbursement rounded to the nearest integer.