MySQL CEIL() Function

The ceil() is a Math function of MySQL. This function returns the smallest value which is greater than or equal to the given number.

Syntax

Parameter:

Num: number for getting ceil value

Returns

This function returns the smallest integer value that is greater than or equal to a number.

Example 1

Output:

Example 2

Output:

Example 3

Output:

Example 4

Output: