Round

Rounds a number to the given number of decimal places. Midpoint values are rounded to the nearest even number (2.5 rounds to 2).

Numeric Round(Numeric value, Numeric decimalPlaces = 0)

Returns 3.14 and 2.

SELECT Round(3.14159, 2) as A, Round(2.5) as B FROM Single

• Scalar Functions