SQLite 3 reference · Math Functions
SQLite CEIL() Function
Return the smallest integer value not less than a number, rounding up: ceil(2.1) is 3. ceiling() is a synonym.
SQLite 3 Since 3.35.0
Syntax
ceil(X) | ceiling(X)
Parameters
| Parameter | Description |
|---|---|
X |
A number (text that looks like a number is converted). |
Return value
An integer for integer input, otherwise a floating-point number.
Examples
SELECT ceil(2.1) AS a, ceil(-2.1) AS b, ceil(5) AS c;
Output
a | b | c 3 | -2 | 5
Run this on your computer — see “Get Started” for setup.
SELECT count(*) AS products, ceil(count(*) / 5.0) AS pages_of_5
FROM products;
Output
products | pages_of_5 12 | 3
Run this on your computer — see “Get Started” for setup.
This is one of SQLite's built-in math functions, available since 3.35.0 when SQLite is compiled with
SQLITE_ENABLE_MATH_FUNCTIONS (the default for the sqlite3 command-line tool and most language bindings). The
in-browser SQLite on this site is built without them, so the examples show output from standard SQLite instead.
Version history
| Version | Change |
|---|---|
| SQLite 3.35.0 | Added |
In other languages
CEIL()· PostgreSQL
Related
FLOOR()· Return the largest integer value not greater than a number, rounding down: floor(2.9) is 2 and floor(-2.1) is -3.ROUND()· Round a number to a given number of decimal places (0 by default). Halves round away from zero.TRUNC()· Drop the fractional part of a number, rounding toward zero: trunc(2.7) is 2 and trunc(-2.7) is -2.- SQL Aggregate Functions · tutorial