Return the greatest whole number that is less than or equal to 25.75.
| SELECT FLOOR(25.75) AS FloorValue; |
The FLOOR() function yields the highest integer less than or equal to a number.
Tip: Consider the CEILING() and ROUND() functions for related functionality.
| FLOOR(number) |
|
Parameter |
Description |
|
number |
Required: A numerical value. |
|
Works in: |
SQL Server (from 2008 onwards), Azure SQL Data Warehouse, and Parallel Data Warehouse |
Provide the greatest integer value that is equal to or less than 25.
| SELECT FLOOR(25) AS FloorValue; |
Provide the greatest integer value that is equal to or less than -13.5.
| SELECT FLOOR(-13.5) AS FloorValue; |