The CEIL functions round the specified number up, and return the smallest number that is greater than or equal to the specified number.
Syntax is:-
CEIL (NUMBER);
Example is:-
SELECT CEILING(12.12);
--> 13
SELECT CEILING(99);
--> 99
SELECT CEILING(-99.99);
--> -99
SELECT CEILING(-32);
--> -32
Read Also:- CEIL function in Teradata
Syntax is:-
CEIL (NUMBER);
Example is:-
SELECT CEILING(12.12);
--> 13
SELECT CEILING(99);
--> 99
SELECT CEILING(-99.99);
--> -99
SELECT CEILING(-32);
--> -32
Read Also:- CEIL function in Teradata
No comments:
Post a Comment