CEIL

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.

2. 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         |
+---------+------------+