Ceil

Returns the smallest whole number that is greater than or equal to the given number.

Numeric Ceil(Numeric value)

Returns 5 and -1.

SELECT Ceil(4.2) as A, Ceil(-1.5) as B FROM Single

• Scalar Functions