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