MySQL CEIL() Function

The MySQL CEIL() function returns the next highest integer value by rounding up the specified number, if necessary. In other words, it rounds the fraction UP of the given number.

The CEIL() function is a synonym for the CEILING() function.

Syntax

CEIL(x)

Parameters

Return Value

Returns the next highest integer value by rounding UP the specified number, if necessary.

Example 1:

The example below shows the usage of CEIL() function.

mysql> SELECT CEIL(23);
Result: 23

mysql> SELECT CEIL(23.3);
Result: 24

mysql> SELECT CEIL(23.8);
Result: 24

mysql> SELECT CEIL(-23);
Result: -23

mysql> SELECT CEIL(-23.3);
Result: -23

mysql> SELECT CEIL(-23.8);
Result: -23

Example 2:

Consider a database table called Sample with the following records:

The statement given below can be used to round the fraction UP for all records of column x.

SELECT *, CEIL(x) AS CEIL_Value FROM Sample;

This will produce the result as shown below: