Use CEILING in MySQL : Floor Ceiling « Math « SQL / MySQL

1. SQL / MySQL
2. Math
3. Floor Ceiling

Use CEILING in MySQL

/*
mysql> select CEILING(-1.4);
+---------------+
| CEILING(-1.4) |
+---------------+
|            -1 |
+---------------+
1 row in set (0.01 sec)

mysql> select CEIL(0.5);
+-----------+
| CEIL(0.5) |
+-----------+
|         1 |
+-----------+
1 row in set (0.01 sec)


*/  
select CEILING(-1.4);
select CEIL(0.5);
           
       

Related examples in the same category