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.

SELECT ceil(COLUMN_NAME) as ALIASNAME
FROM DATASET;

Example

This example takes the ceiling of the Profit field.

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