MySQL CEILING() Function

Return the smallest integer value that is greater than or equal to 25.75

Definition and Usage

The CEILING() function returns the smallest integer value that is bigger than or equal to a number.

Note: This function is equal to the CEIL() function.

Syntax

CEILING(number)

Parameter Values

Parameter Description
number Required. A numeric value

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Return the smallest integer value that is greater than or equal to 25:

SELECT CEILING(25);