Example
Round the number to 2 decimal places:
sql
SELECT ROUND(135.375, 2);
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
text
ROUND(number, decimals)
Parameter Values
| Parameter | Description |
|---|---|
| number | Required. The number to be rounded |
| decimals | Optional. The number of decimal places to round number to. If omitted, it returns the integer (no decimals) |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Round the number to 0 decimal places:
sql
SELECT ROUND(345.156,
0);
Example
Round the Price column (to 1 decimal) in the "Products" table:
sql
SELECT ProductName, Price, ROUND(Price, 1) AS RoundedPrice
FROM Products;