Syntax
Purpose
CEIL returns smallest integer greater than or equal to n. Example
SELECT CEIL(15.7) "Ceiling" FROM DUAL; Ceiling
----------
16
Purpose
CEIL returns smallest integer greater than or equal to n. Example
SELECT CEIL(15.7) "Ceiling" FROM DUAL; Ceiling
----------
16
select ceil(15.5) from dual;
select floor(15.4) from dual;
select floor(15.5) from dual;看看结果你就知道是怎么回事了。