CEIL
The CEIL
function returns the smallest integer greater than or equal to Expression
.
SQL syntax
CEIL(Expression)
Parameters
CEIL
has the parameter:
Parameter | Description |
---|---|
|
Operand or column can be any numeric data type. |
Description
-
If
Expression
is of typeNUMBER
, the data type returned isNUMBER
with maximum precision and scale. Otherwise,CEIL
returns the same data type as the numeric data type ofExpression
. -
If the value of
Expression
isNULL
,NULL
is returned. If the value ofExpression
is-INF
,INF
, orNaN
, the value returned is-INF
,INF
, orNaN
respectively.
Examples
Sum the commission_pct
for employees in the employees
table, and then call CEIL
to return the smallest integer greater than or equal to the value returned by SUM
. You see the value returned by the SUM
function is 7.8 and the value returned by the CEIL
function is 8.
Command> SELECT SUM (commission_pct) FROM employees; < 7.8 > 1 row found. Command> SELECT CEIL (SUM (commission_pct)) FROM employees; < 8 > 1 row found.