---
schema_version: "1"
id: 55490304015da034e025e1c9035c6b51baa0880f9dbd8824d995413fd3da5ddd
title: round({n}[,{m}])
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-math-round.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-math-round.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 5bf7b2363cd091ae98a620c4a7d24dc09230d625c31843a59191b31eccea0884
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# round({n}[,{m}])

Returns the value of _n_ rounded to _m_ decimal places. _m_ can be negative, in which case the function returns _n_ rounded to -_m_ places to the left of the decimal point. If _m_ is omitted, it returns _n_ rounded to the nearest integer. For tie-breaking, it follows round half way from zero convention. _n_ can be any real numeric value in the range of -1.797e308 \<= _n_ \<= 1.797e308. _m_ can be an integer value between -15 and 15, inclusive.

`round({n}[,{m}])` takes the following syntax.

```nolang
SELECT round(N[,M]) as AliasName
FROM dataset;
```

## Example

This example returns 47.385 rounded to the first decimal place.

```nolang
SELECT round(47.385, 1) as roundExample FROM Superstore
LIMIT 1;
```

| roundExample |
| ------------ |
| 47.4         |