Example
Round the number to 2 decimal places:
SELECT ROUND(235.415, 2) AS RoundValue;
Definition and Usage
The ROUND() function rounds a number to a specified number of decimal places.
Tip: Also look at the FLOOR() and CEILING() functions.
Syntax
ROUND(number, decimals, operation)