`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.

1SELECT ceil(COLUMN_NAME) as ALIASNAME
2FROM DATASET;

Example

This example takes the ceiling of the Profit field.

1SELECT ceil(Profit) as ceilProfit
2FROM Superstore
3LIMIT 1;

ceilProfit
42