CEIL
On this page
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 |
+------------+----------------+Last modified: February 24, 2023