# 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         |