Definition: Floor is used to round a number down to the last whole number. Any number with even the highest decimal is rounded down. This is the opposite of Ceiling which rounds everything up.
Also Known As: Round number down
Examples:
SELECT FLOOR(-3.14);This would round down to -4
SELECT FLOOR(3.14);This would round down to 3
