CEIL function is to return the smallest integer value greater than or equal to the supplied number.
It essentially rounds up to the nearest whole number, and is the opposite of the FLOOR function (which rounds down to the nearest whole number).
SELECT CEIL(41.86) FROM DUAL
42
SELECT CEIL(41.22) FROM DUAL
42
SELECT FLOOR(41.86) FROM DUAL
41
SELECT FLOOR(41.22) FROM DUAL
41
It essentially rounds up to the nearest whole number, and is the opposite of the FLOOR function (which rounds down to the nearest whole number).
SELECT CEIL(41.86) FROM DUAL
42
SELECT CEIL(41.22) FROM DUAL
42
SELECT FLOOR(41.86) FROM DUAL
41
SELECT FLOOR(41.22) FROM DUAL
41
No comments:
Post a Comment