MySQL CEIL() Function

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP







<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]
-->



MySQL CEIL() Function



❮ MySQL Functions



Example


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



SELECT CEIL(25.75);

Try it Yourself »

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





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 CEIL(25);

Try it Yourself »


❮ MySQL Functions


-