[SQL] CEIL(), FLOOR()

  . CEIL()

SELECT CEIL(15.7) "Ceiling" FROM DUAL;

  Ceiling

----------

16

  . FLOOR()

SELECT FLOOR(15.7) "Floor" FROM DUAL;

    Floor

----------

15

  . ex) SELECT CEIL(123.23), FLOOR(123.23) FROM DUAL;

CEIL(123.23) FLOOR(123.23)

------------ -------------

124           123