ROUND
Rounds a number to the given precision.
Syntax
ROUND ( expression, precision )
Arguments
expression: any valid numeric expression.
precision: the number of digits after the decimal to round to.
Return Type
Float or double.
Examples
SELECT ROUND(3.14159, 0), ROUND(3.14159, 2); **** +-------------------+-------------------+ | ROUND(3.14159, 0) | ROUND(3.14159, 2) | +-------------------+-------------------+ | 3 | 3.14 | +-------------------+-------------------+