---
schema_version: "1"
id: 1179b6bfb4369713ad5dfa772fb9993339fdf2e086c11e57bd2f5a33ef47d128
title: ceil({n}), ceiling({n})
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-ceil.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-math-ceil.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 45f67b654a558a13eaf23aa1a851c85e6c557034652fbd6b871708cf5c2b8b1f
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# ceil({n}), ceiling({n})

Returns the nearest integer of equal or greater value to _n_. _n_ can be any real numeric value in the range of -1.797e308 \<= _n_ \<= 1.797e308.

`ceil({n})` takes the following syntax.

```nolang
SELECT ceil(COLUMN_NAME) as ALIASNAME
FROM DATASET;
```

## Example

This example takes the ceiling of the Profit field.

```nolang
SELECT ceil(Profit) as ceilProfit
FROM Superstore
LIMIT 1;
```

| ceilProfit |
| ---------- |
| 42         |