ROUND
Rounds a value to a specified number of decimal places.
Syntax
ROUND(<val> [, <dec>])
| Parameter | Description |
|---|---|
<val> | Valid values include column names, functions that return a column with numeric values, and constant numeric values. |
<dec> | Optional. An INT constant that defines the decimal range of the returned value. By default, ROUND returns whole numbers. |
Example
SELECT
ROUND(5.4);
Returns: 5
SELECT
ROUND(5.6930, 1);
Returns: 5.7