SQL ROUND Function

The SQL ROUND() function rounds a number to a specific length or precision. Here is the syntax:

	ROUND(<numeric expression>,<precision>)

Here is a query example:

	SELECT ROUND(10.09 ,1) positive_rounded_value,
		   ROUND(10.09 ,-1) negative_rounded_value

And the output is:

positive_rounded_value  negative_rounded_value
----------------------  ----------------------
                  10.1                      10

Menu