Returns expression1 rounded to expression2 decimal places. The first argument (expression1) can be any built-in numeric data type. The second argument (expression2) can be a small or large integer. The absolute value of the second argument specifies the number of decimal places. If the second argument is positive, the first argument is rounded to the right of the decimal point. If the second argument is zero or negative, the first argument is rounded to the left of the decimal point.
Example:
Calculate the number 873.726 rounded to 2, 1, 0, -1, -2, -3, and -4 decimal places respectively.
SELECT ROUND(873.726, 2), ROUND(873.726, 1), ROUND(873.726, 0), ROUND(873.726, -1), ROUND(873.726, -2), ROUND(873.726, -3), ROUND(873.726, -4) FROM TABLEX
This example returns: 0873.730 0873.700 0874.000 0870.000 0900.000 1000.000 0000.000 respectively.