Explain CEILING() Function in SQL?

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

Syntax :

CEILING(number)

Parameter : Required. A numeric value.

number : It is a numeric value.

Returns : It returns the integer value.

Example:

When the argument holds a positive number.

SELECT CEILING(21.53);

Output :

22