MySQL CEILING() Function

The ceiling() 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: It is the number for getting ceiling value.

Returns

This function returns the smallest value which is greater than or equal to the given number.

Example 1

Output:

Example 2

Output:

Example 3

Output: