CEILING()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Returns the smallest integer value that is not less than the given argument.
EXAMPLES
CREATE TABLE ceiling_example (
example FLOAT
);
INSERT INTO ceiling_example VALUES
(1.1), (42.5), (99.9), (7.0), (11.2);
SELECT example, CEIL(example) FROM ceiling_example;
+---------+---------------+
| example | CEIL(example) |
+---------+---------------+
| 1.1 | 2 |
| 42.5 | 43 |
| 99.9 | 100 |
| 7 | 7 |
| 11.2 | 12 |
+---------+---------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.