SQL ROUND Function

The SQL ROUND function is one of the SQL Mathematical Function, which is used to round the specified numeric expression, or an individual number to user specified length or precision.

SQL ROUND Function Syntax

The basic syntax of the SQL Server ROUND Function is:

• Numeric_Expression: It can be a number or a valid numerical expression, or approximate numeric data type expect bit type.
• Length: It is the precision to which the Numeric_Expression is to be rounded. Length can be a number or a valid numerical expression of type tinyint, smallint, or int.
  • If the length argument is positive number, Round function will round the Numeric_Expression to the number of decimal point specified as length.
  • If the length argument is negative number, Numeric_Expression can be rounded to the left side of the decimal point.
• Function: This is an optional parameter and it must be type tinyint, smallint, or int. If we omit this parameter, or if we assign the default 0 then Numeric_Expression will be rounded. If we specify the function value other than 0 then, Numeric_Expression will be truncated.

SQL ROUND Function Example 1

The SQL Server ROUND Function is used to return the rounded numeric value. The following query will show multiple ways to use ROUND function.

T-SQL CODE

OUTPUT

ANALYSIS

Below lines of code is used to declare float variable and assigning the value.

In the below statement, We used ROUND function to find the rounded numeric value of the variable @i. We also assigned new name to that result as ‘Round_Result 1’ using ALIAS Column.

In the next statement, We used the ROUND Function with negative length value.

In the below statement, We used the ROUND Function to showcase the truncation.

SQL ROUND Function Example 2

In this example, We are going to find the rounded numeric values for all the records present in [List Price] using ROUND Function.

T-SQL CODE

OUTPUT

Thank You for Visiting Our Blog