ROUND

Rounds a value to a specified number of decimal places.

Syntax

ROUND(<value> [, <decimal>])

Parameters

Parameter Description Supported input types
<value> The value to be rounded  
<decimal> Optional. An INTEGER constant that defines the decimal range of the returned value. By default, ROUND returns whole numbers. INTEGER

Return Types

DOUBLE PRECISION

Example

The following example returns the rounded value of 5.4. Since there is no specification of the decimal range, the functions returns a whole number:

SELECT
    ROUND(5.4);

Returns: 5

The following example rounds the value 5.6930 to 1 decimal place:

SELECT
    ROUND(5.6930, 1);

Returns: 5.7