Example
Return the largest integer value that is equal to or less than 25.75:
SELECT FLOOR(25.75) AS FloorValue;
Definition and Usage
The FLOOR() function returns the largest integer value that is smaller than or equal to a number.
Tip: Also look at the CEILING() and ROUND() functions.
Syntax
FLOOR(number)