CEIL()

Scalar. Returns the smallest integer value greater than or equal to a specific value.

Syntax

CEIL( expression )
Data Types

Return

expression

Float

Integer

Long

Float

Example

The following example returns the smallest integer greater than or equal to 3.45:

INSERT INTO OutStream
SELECT CEIL(3.45)
FROM Devices;