Sql-CEILING and Floor

CEILING

Returns the smallest integer that is greater than, or equal to, the given numeric expression.

for instance,
SELECT ceiling(1.5) will return "2"
--------------------------------------------------------------------------------

FLOOR

Returns the largest integer less than or equal to the given numeric expression

for instance SELECT floor(1.5)
will return "1"