​
Overview

The CEIL() function returns the nearest positive or negative integer value greater than or equal to the provided decimal input number.

​
Syntax

The syntax of the CEIL() function is as follows:

CEIL(x)

The CEIL() function requires one argument:

  • x: A positive or a negative decimal number (or an expression that evaluates to a decimal number).

​
Examples

​
Case #1: Rounding up a positive decimal value

The following example demonstrates how the CEIL() function rounds up a positive decimal value:

SELECT CEIL (300.55);

As shown below, it will return 301, as it is the nearest integer value greater than 300.55.

+------+
| f    |
+------+
| 301  |
+------+

​
Case #2: Rounding up a negative decimal value

The following example demonstrates how the CEIL() function rounds up a negative decimal value:

SELECT CEIL(-89.9) AS "Ceil";

The output of this statement will be -89, as -89 is the nearest integer value greater than or equal to -89.9, as shown below.

+-------+
| Ceil  |
+-------+
| -89   |
+-------+

​
Case #3: Using the CEIL() function with a table

The following example demonstrates how the CEIL() function can be used with a table to round up the values in a specific column:

  1. First, create a table called CeilRecords with the following query:
CREATE TABLE CeilRecords (numbers float);
  
INSERT INTO CeilRecords(numbers) 
VALUES 
    (-28.85),
    (-9.4),
    (0.87),
    (78.16),
    (42.16);

The above statement will create a table called “CeilRecords” with a column called “numbers” and insert 5 decimal values into it.

  1. The statement below can be used to retrieve and round up the value for all records in the column *numbers:
SELECT *, CEIL(numbers) AS CeilValue FROM CeilRecords;

The final result will contain the following:

  • A numbers column with initial decimal values.

  • A CeilValue column with rounded-up integer values.

+---------+------------+
| numbers  | CeilValue  |
+---------+------------+
| -28.85  | -28        |
| -9.4    | -9         |
| 0.87    | 1          |
| 78.16   | 79         |
| 42.16   | 43         |
+---------+------------+

“

CBRTEXP