Returns the lowest integer greater than or equal to a number.

Syntax

---

CEILING(<NumericExpression>)
CEIL(<NumericExpression>)

<NumericExpression> =

Type of:

SMALLINT
INTEGER|INT
BIGINT
FLOAT
DECIMAL|NUMERIC

Returns

---

INTEGER

Usage

---

The CEIL or CEILING function returns the lowest integer greater than or equal to a number.

Examples

---

SELECT SUM(CEIL(Distance)) AS ApproxDistance
FROM Destinations

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: