Round Function

The round() function rounds a floating-point value up to a number of digits to the right of the decimal point. If the 2nd argument (rounded digits) is omitted, it is assumed to be 0.

The syntax is simple Round( Floating Point Number , [ Number ]).

SELECT ROUND(10.7578690); /* returns 11 */ ;

SELECT ROUND(10.7578690 , 2) /* returns 10.76 */ ;

SELECT ROUND(10.7578690 , 4) /* returns 10.7579 */ ;

SELECT ROUND(10.7578690 , 10) /* returns 10.757869 */ ;