Skip to main content

CEIL

Rounds a number up to the next highest integer.

Syntax

CEIL ( expression )
CEILING ( expression )

Arguments

  • expression: any valid numeric expression.

Return Type

Integer.

Examples

SELECT CEIL(98.6), CEILING(-98.6);
****
+------------+----------------+
| CEIL(98.6) | CEILING(-98.6) |
+------------+----------------+
|         99 |            -98 |
+------------+----------------+