ceil
Returns values from <input_expr> rounded to the nearest equal or larger integer.
Syntax
Section titled “Syntax”ceil( <input_expr> )Returns
Section titled “Returns”The return type is float.
Arguments
Section titled “Arguments”<input_expr>
Section titled “<input_expr>”The value or expression to operate on. The data type should be float.
Examples
Section titled “Examples”SELECT ceil(135.135), ceil(-975.975), ceil(2.5), ceil(-2.5);+---------------+-----------------+-----------+-------------+| ceil(135.135) | ceil(- 975.975) | ceil(2.5) | ceil(- 2.5) |+---------------+-----------------+-----------+-------------+| 136.0 | -975.0 | 3.0 | -2.0 |+---------------+-----------------+-----------+-------------+