# **ceiling()**

## **Function Description**

The ceiling(X) function returns the smallest integer not less than X. [`ceil()`](ceil.md) is synonymous.

## **Function Syntax**

```text
> ceiling(X)
```

## **Parameter definition**

| Parameters | Description |
| ---- | ---- |
| X | Required parameters, any numerical data type can be taken |

For the absolute numeric type of the int class, the return value is also the same absolute numeric type. For floating-point numbers, the return value is also a floating-point number.

## **Example**

```text
drop table if exists t1;
create table t1(a int ,b float);
insert into t1 values(1,0.5);
insert into t1 values(2,0.499);
insert into t1 values(3,0.501);
insert into t1 values(4,20.5);
insert into t1 values(5,20.499);
insert into t1 values(6,13.500);
insert into t1 values(7,-0.500);
insert into t1 values(8,-0.499);
insert into t1 values(9,-0.501);
insert into t1 values(10,-20.499);
insert into t1 values(11,-20.500);
insert into t1 values(12,-13.500);

mysql> select a,ceiling(b) from t1;
+-------+-----------------+
| a | ceiling(b) |
+-------+-----------------+
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 21 |
| 5 | 21 |
| 6 | 14 |
| 7 | -0 |
| 8 | -0 |
| 9 | -0 |
| 10 | -20 |
| 11 | -20 |
| 12 | -13 |
+-------+-----------------+
12 rows in set (0.00 sec)

mysql> select sum(ceiling(b)) from t1;
+-----------------------+
| sum(ceiling(b)) |
+-----------------------+
| 6 |
+-----------------------+
1 row in set (0.01 sec)
```