MySQL ROUND() Function

❮ MySQL Functions

Example

Round the number to 2 decimal places:

SELECT ROUND(135.375, 2);

Try it Yourself »

---

Definition and Usage

The ROUND() function rounds a number to a specified number of decimal places.

Note: See also the FLOOR(), CEIL(), CEILING(), and TRUNCATE() functions.

Syntax

ROUND(number, decimals)

Resource:https://www.w3schools.com/sql/func_mysql_round.asp