bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MySQL CEIL() Function

Example

SELECT CEIL(25.75);

Definition and Usage

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

Note

This function is equal to the CEILING() function.

Syntax

CEIL(
number
)

Parameter Values

ParameterDescription
numberRequired. A numeric value

Technical Details

Works in:From MySQL 4.0

Previous

MySQL AVG() Function

Next

MySQL CEILING() Function