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)
area | angle | num |
36.784 | 45 | 96 |
212.254 | 30 | -78 |
121.001 | 45 | -45 |
141.698 | 185 | -96 |
EXAMPLE:
SELECT ceil(area) as Area from scanf ;This would produce following result:
Area 37 212 121 142