CEIL function in MariaDB

The CEIL functions round the specified number up, and return the smallest number that is greater than or equal to the specified number.

Syntax is:-

CEIL (NUMBER)

Example is:-

SELECT CEIL(11.5);
--> 12

SELECT CEIL(11.1);
--> 12

SELECT CEIL(11);
--> 11

SELECT CEIL(-11.7);
--> -11

SELECT CEIL(-11.3);
--> -11

SELECT CEIL(-11);
--> -11


Read Also:-  CEIL function in MySql