Link Search Menu Expand Document

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