# ROUND

Rounds a number to the given precision.

## Syntax

```sql
ROUND ( expression, precision )

```

## Arguments

* expression: any valid numeric expression.
* precision: the number of digits after the decimal to round to.

## Return Type

Float or double.

## Examples

```sql
SELECT ROUND(3.14159, 0), ROUND(3.14159, 2);

```

```output

+-------------------+-------------------+
| ROUND(3.14159, 0) | ROUND(3.14159, 2) |
+-------------------+-------------------+
|                 3 |              3.14 |
+-------------------+-------------------+

```

***

Modified at: February 24, 2023

Source: [/db/v9.1/reference/sql-reference/numeric-functions/round/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/numeric-functions/round/)

(An index of the documentation is available at /llms.txt)