ceil

description

Syntax

BIGINT ceil(DOUBLE x) 返回大于或等于x的最小整数值.

example

1. mysql> select ceil(1);
2. +-----------+
3. | ceil(1.0) |
4. +-----------+
5. |         1 |
6. +-----------+
7. mysql> select ceil(2.4);
8. +-----------+
9. | ceil(2.4) |
10. +-----------+
11. |         3 |
12. +-----------+
13. mysql> select ceil(-10.3);
14. +-------------+
15. | ceil(-10.3) |
16. +-------------+
17. |         -10 |
18. +-------------+

keywords

1. CEIL