CEIL
A synonym for CEILING: rounds a number up to the nearest integer.
MySQL 8.1
CEIL(num)Parameters
- numDECIMAL
- Number to round
Return value
The smallest integer that is not less than num
Examples
Rounding up
MySQL 8.1
SELECT CEIL(4.1) AS up,
CEIL(-4.9) AS negative_up;Number of pages with 3 rows each
MySQL 8.1
SELECT COUNT(*) AS members,
CEIL(COUNT(*) / 3) AS pages_of_3
FROM FamilyMembers;