Returns numeric_exp rounded to integer_exp places right of the decimal point. If integer_exp is negative, numeric_exp is rounded to |integer_exp| places to the left of the decimal point.

 

Example:

SELECT ROUND(75.12345678,3) returns 75.123

 

Example:

SELECT ROUND(75.12345676,7) returns 75.1234568