Other related articles:

Recently viewed articles:

SQL FLOOR Function

SQL FLOOR function is very much similar to ROUND function, except that SQL FLOOR function always rounds to next lowest integer values. SQL FLOOR function removes all numbers after decimal place and round the values to next lower integer value. FLOOR is exact opposite of CEIL function.

The syntax is
FLOOR (number);

Examples:
The following SQL statements illustrate the use of SQL FLOOR function on couple different numbers:

SELECT FLOOR (2.32) FROM DUAL;

OUTPUT:
sql floor image1

SELECT FLOOR (6.79) FROM DUAL;

OUTPUT:
sql floor image2

SELECT FLOOR (-5.45) FROM DUAL;

OUTPUT:
sql floor image3

SELECT FLOOR (-10.99) FROM DUAL;

OUTPUT:
sql floor image4
Note: the numbers are always rounded to no decimal places and to next lower integer by SQL FLOOR function.