ROUND Function - SQL

Overview

The ROUND function in SQL rounds a numeric expression to a specified number of decimal places. It is useful for controlling the precision of numeric outputs.

Example:

SELECT ROUND(123.4567, 2)

Syntax:

SELECT ROUND(numeric_expression, decimal_places)

numeric_expression is the number you want to round.

decimal_places specifies the number of decimal places to round to. If omitted, it rounds to the nearest whole number.