Answer: This post is related with ORACLE
----------------------------------------------
The CEILING function does the opposite of FLOOR function. It returns the smallest integer greater than the value you specify.
Syntax:-
CEILING(expression)
Example:-
SELECT CEILING(400.45)
It will output 401.
NOTE:- It rounds up the non-integer number to the next highest value. If you enter negative value, it will return the lower absolute value.
Example:-
SELECT CEILING(-400.45)
It will output -400.
======================================================================
The author couldn't update this after PandianS response so this post has been updated by Moderator based on PandianS response.
Asked In: Many Interviews |
Alert Moderator