Numbers & math Scalar

ceil()

Rounds the number up

Arguments & returns

3 overloads

Scalar

SELECT ceil(17.4);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Used in larger rewrites 1

These examples use ceil as one part of a larger SQL translation.

SELECT CEIL(1.753, 2)

In Haybarn

SELECT ROUND(CEIL(1.753 * POWER(10, 2)) / POWER(10, 2), 2)