Skip to main content

CEILING

Returns the smallest integer value not less than x.

Syntax​

CEILING(x)

Arguments​

ArgumentsDescription
xThe numerical value.

Return Type​

A Float64 data type value.

Examples​

SELECT CEILING(1.23);
+---------------+
| CEILING(1.23) |
+---------------+
|             2 |
+---------------+

SELECT CEILING(-1.23);
+-------------------+
| CEILING((- 1.23)) |
+-------------------+
|                -1 |
+-------------------+