CEIL (expression)
CEILING (expression)

Parameters

• expression - any valid numeric expression.

Description

See also Java Math.ceil. This method returns a double.

Example

Calculate a ceiling price for items:

SELECT item_id, CEILING(price) FROM Items;