ceiling.txt

MariaDB [(none)]> select ceiling(200.4);
+----------------+
| ceiling(200.4) |
+----------------+
|            201 |
+----------------+
1 row in set (0.04 sec)

MariaDB [(none)]> select ceiling(1.9);
+--------------+
| ceiling(1.9) |
+--------------+
|            2 |
+--------------+
1 row in set (0.00 sec)

MariaDB [(none)]> select ceiling(28.11);
+----------------+
| ceiling(28.11) |
+----------------+
|             29 |
+----------------+
1 row in set (0.00 sec)

MariaDB [(none)]> select ceiling(28.00001);
+-------------------+
| ceiling(28.00001) |
+-------------------+
|                29 |
+-------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> select ceiling(0.0001);
+-----------------+
| ceiling(0.0001) |
+-----------------+
|               1 |
+-----------------+
1 row in set (0.00 sec)

MariaDB [(none)]> select ceiling(0);
+------------+
| ceiling(0) |
+------------+
|          0 |
+------------+
1 row in set (0.00 sec)