CEIL()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
See CEILING().
USAGE
CEIL(number)
Argument Name | Description |
|---|---|
| The number to round |
EXAMPLES
CREATE TABLE ceil_example (
example FLOAT
);
INSERT INTO ceil_example VALUES
(1.1), (42.5), (99.9), (7.0), (-11.2);
SELECT example, CEIL(example)
FROM ceil_example;
+---------+---------------+
| example | CEIL(example) |
+---------+---------------+
| 1.1 | 2 |
| 42.5 | 43 |
| 99.9 | 100 |
| 7 | 7 |
| -11.2 | -11 |
+---------+---------------+