ROUND

Returns a numeric expression rounded to the specified length or precision.

Note: This function is equivalent to ROUND in T-SQL.

Return Value

Numeric

Syntax

ROUND( numExpr, length )

where:

numExpr is the numeric expression containing the value you want to have rounded.
length indicates the number of places or the precision to which the number should be rounded.

When length is a positive number, numExpr is rounded to the number of decimal positions specified by length. When length is a negative number, numExpr is rounded on the left side of the decimal point, as specified by length.