Loading lesson path
Concept visual
Start at both ends
Return the smallest integer value that is greater than or equal to a number:
SELECT CEILING(25.75) AS CeilValue;The CEILING() function returns the smallest integer value that is larger than or equal to a number.
and
functions.
number )
Required. A numeric value
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
Return the smallest integer value that is greater than or equal to a number:
SELECT CEILING(25) AS CeilValue;Return the smallest integer value that is greater than or equal to a number:
SELECT CEILING(-13.5) AS CeilValue;❮ SQL Server Functions