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)

database table 'scanf'

area

angle

num

36.7844596
212.25430-78
121.00145-45
141.698185-96

EXAMPLE:

select floor(area) as Area from scanf  ;
This would produce following result:
Area
36
212
121
141



Online Execute/Compile