CEILING function [Numeric]

Returns the ceiling (smallest integer not less than) of a number.

CEILING ( numeric-expression )

The following statement returns the value 60.00000.

SELECT CEILING( 59.84567 ) FROM iq_dummy

The following statement returns the value 123.

SELECT CEILING( 123 ) FROM iq_dummy

The following statement returns the value 124.00.

SELECT CEILING( 123.45 ) FROM iq_dummy

The following statement returns the value -123.00.

SELECT CEILING( -123.45 ) FROM iq_dummy