ROUND

Returns a number rounded to the specified precision (number of decimal places).

Usage examples 

  • ROUND(1.6)

  • ROUND(43.56, 1)

  • ROUND(tableA.fieldB)

Syntax 

ROUND ( value, [ places ] )

  • value - Any numeric expression.

  • places - Any numeric expression for the number of decimal places. 0 by default.

Returns 

number - The rounded number.

Functions reference