SingleStore Managed Service

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 |
+------------+----------------+