Previous Next JavaScript must be enabled to correctly display this content

## ceil function

The `ceil` function returns the smallest integer that is greater than or equal to the specified expression.

Syntax:

    number ceil(n)

Semantics:

- n: The argument n is an expression that resolves to a number.
- return type:
  - Returns the same type as the argument n.
  - Returns a NULL value in the following cases:
    - n resolves to a NULL value
    - n does not resolve to a number
  - Returns NaN if n resolves to NaN.
  - Returns a positive/negative infinity if n resolves to the respective infinity.
  - Returns a positive/negative zero if n resolves to the respective zero value.

Example 12-76 ceil function

    SELECT ceil(n) FROM Userstocks

Value of n | Output
--- | ---
1.34 | 2.0
-1.34 | -1.0
pi() | 4.0