SQL CEILING()

CEILING function in SQL is used to get back the smallest integer value that is not less than previous passed numeric expression.


SYNTAX :
ceil(x)

database table 'scanf'

area

angle

num

36.7844596
212.25430-78
121.00145-45
141.698185-96

EXAMPLE:

SELECT ceil(area) as Area from scanf ;
This would produce following result:
Area
37
212
121
142



Online Execute/Compile

Quantitative Aptitude
Reasoning
Programming
Interview