SQL CEILING Function

Example

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

SELECT CEILING(25.75) AS CeilValue;

Definition and Usage

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

Tip: Also look at the FLOOR() and ROUND() functions.

Syntax

CEILING(number)

Continue reading SQL CEILING Function