Returns the ceiling (smallest integer not less than) of a number.
CEIL is as synonym for CEILING.
DOUBLE
SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Compatible with Adaptive Server Enterprise.
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