MySQL CEIL() Function

The CEIL() function in MySQL rounds a number *up* to the nearest integer. This means it always increases the number to the next whole number, discarding any fractional part.

CEIL(): Definition and Usage

CEIL() is very useful when you need to work with whole numbers and want to make sure that any fractional part of a number is always rounded upwards. This is often necessary in situations where you need to perform calculations based on the next highest integer.

Syntax


CEIL(number)

Parameter Values

Parameter	Description
`number`	The number you want to round up. This is required and must be a numeric value.

Equivalent Function: CEILING()

The CEILING() function is identical to CEIL(); both perform the same upward rounding.

Examples

Rounding Up a Decimal Number

This example rounds the number 25.75 up to 26.

Syntax


SELECT CEIL(25.75);

Output

Rounding Up a Whole Number

If the input number is already a whole number, CEIL() returns the same number.

Syntax


SELECT CEIL(25);