SQL FLOOR()
FLOOR function in SQL is used to bring lowest integer that is less than or equal to that given numeric expression.SYNTAX :
floor(x)
area | angle | num |
36.784 | 45 | 96 |
212.254 | 30 | -78 |
121.001 | 45 | -45 |
141.698 | 185 | -96 |
EXAMPLE:
select floor(area) as Area from scanf ;This would produce following result:
Area 36 212 121 141