ROUND
Rounds a value to a specified number of decimal places.
Syntax
ROUND(<value> [, <decimal>])
| Parameter | Description |
|---|---|
<value> | Valid values include column names, functions that return a column with numeric values, and constant numeric values. |
<decimal> | Optional. An INTEGER 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