Important Points About SQL Server ROUND Function

  • The ROUND() function is used to round off a specified number to a specified number of decimal places.
  • It accepts various types of numbers, including positive, negative, and zero.
  • The return type of the ROUND() function depends on the input number type.
  • The ROUND() function uses the rounding-to-the-nearest-digit algorithm.

SQL Server ROUND() Function

The SQL Server ROUND() function rounds off a specified number to a decimal place.

Similar Reads

ROUND in SQL Server

The ROUND() function in SQL Server rounds off a number to a specified decimal place. It accepts positive, negative, and zero values....

Syntax

The SQL Server ROUND Function syntax is:...

SQL Server ROUND Function Examples

Let’s look at some example of the ROUND function in SQL Server. Understanding SQL Server ROUND Function with examples, will help in learning the concept better....

Important Points About SQL Server ROUND Function

The ROUND() function is used to round off a specified number to a specified number of decimal places. It accepts various types of numbers, including positive, negative, and zero. The return type of the ROUND() function depends on the input number type. The ROUND() function uses the rounding-to-the-nearest-digit algorithm....