CEIL()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
See CEILING().
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 | 12 |
+---------+---------------+