# round

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: round
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-functions/math-functions/round
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-functions/math-functions/round.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-functions/math-functions/round.adoc
description: The `round()` function rounds numbers using round half to even method (bankers rounding).
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/math-functions/round.md -->

The `round()` function rounds numbers using round half to even method (bankers rounding).

## [](#syntax)Syntax

```sql
ROUND(number)
ROUND(number, scale)
```

## [](#arguments)Arguments

-   `number`: The number to round. It can be positive, negative, or zero, and it can be an [Integer](https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-data-types/numeric-type/numeric/) or a [Double Precision](https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-data-types/numeric-type/numeric/).

-   `scale`: Optional. An integer specifying the number of decimal places to round to. When omitted, the function rounds to the nearest integer. A negative scale rounds to the left of the decimal point (for example, `ROUND(1234, -2)` returns `1200`).


## [](#examples)Examples

### [](#round-to-integer)Round to integer

In this example, the function rounds decimal numbers to integers:

```sql
SELECT
    round(28.11) AS "round(28.11)",
    round(12.51) AS "round(12.51)",
    round(-9.11) AS "round(-9.11)",
    round(102.5) AS "round(102.5)",
    round(101.5) AS "round(101.5)",
    round(-40.51) AS "round(-40.51)";
```

The query will return the nearest integer for all provided values.

```sql
 round(28.11) | round(12.51) | round(-9.11) | round(102.5) | round(101.5) | round(-40.51)
--------------+--------------+--------------+--------------+---------------+---------------
           28 |           13 |           -9 |          102 |          102 |           -41
```

### [](#round-to-a-specific-number-of-decimal-places)Round to a specific number of decimal places

Use the two-argument form to specify the number of decimal places:

```sql
SELECT
    round(3.14159, 2) AS "round(3.14159, 2)",
    round(123.456, 1) AS "round(123.456, 1)",
    round(99.995, 2) AS "round(99.995, 2)";
```

```sql
 round(3.14159, 2) | round(123.456, 1) | round(99.995, 2)
-------------------+-------------------+------------------
              3.14 |             123.5 |              100
```