Example

Round the number to 2 decimal places:

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 , , , and functions.

Syntax

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:

SELECT ROUND(345.156, 0);

Example

Round the Price column (to 1 decimal) in the "Products" table:

SELECT ProductName, Price, ROUND(Price, 1) AS RoundedPrice
FROM Products;


Login
ADS CODE