Returns the smallest integer value that is greater than or equal to the argument. The argument is an expression that returns a value of any built-in numeric data type.
Example:
Find the highest monthly salary for all the employees. Round the result up to the next integer. The SALARY column has a decimal data type.
SELECT CEIL(MAX(SALARY)/12 FROM CORPDATA.EMPLOYEE