Loading lesson path
Concept visual
Start at both ends
Return the largest integer value that is equal to or less than 25.75:
SELECT FLOOR(25.75) AS FloorValue;The FLOOR() function returns the largest integer value that is smaller than or equal to a number.
and
functions.
number )
Required. A numeric value
SQL Server (starting with 2008), Azure SQL Data Warehouse, Parallel Data
Return the largest integer value that is equal to or less than 25:
SELECT FLOOR(25) AS FloorValue;Formula
Return the largest integer value that is equal to or less than - 13.5:SELECT FLOOR(-13.5) AS FloorValue;❮ SQL Server Functions