SQL CEIL Function
SQL CEIL function is very much similar to ROUND function, except that SQL CEIL function always rounds to next highest integer values. SQL CEIL function removes all numbers after decimal place and round the values to next higher integer value. The syntax is
CEIL (number);
Examples:
The following SQL statements illustrate the use of SQL CEIL function on couple different numbers:
SELECT CEIL (2.32) FROM DUAL;
OUTPUT:
SELECT CEIL (6.79) FROM DUAL;
OUTPUT:
SELECT CEIL (-5.45) FROM DUAL;
OUTPUT:
SELECT CEIL (-10.99) FROM DUAL;
OUTPUT: -
Note: the numbers are always rounded to no decimal places and to next higher integer by SQL CEIL function.