CEIL
The CEIL() function returns the nearest positive or negative integer value greater than or equal to the provided decimal input number.
The syntax of the CEIL() function is as follows:
The CEIL() function requires one argument:
- x: A positive or a negative decimal number (or an expression that evaluates to a decimal number).
The following example demonstrates how the CEIL() function rounds up a positive decimal value:
As shown below, it will return 301, as it is the nearest integer value greater than 300.55.
The following example demonstrates how the CEIL() function rounds up a negative decimal value:
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.
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:
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:
The final result will contain the following:
- A numbers column with initial decimal values.
- A CeilValue column with rounded-up integer values.
ļ»æ
