Loading lesson path
Concept visual
Start at both ends
Return the largest integer value that is less than or equal to 25.75:
SELECT FLOOR(25.75);The FLOOR() function returns the largest integer value that is smaller than or equal to a number.
ROUND(), CEIL(), CEILING(), TRUNCATE(), and
functions.
number )
Required. A numeric value
From MySQL 4.0
Return the largest integer value that is less than or equal to 25:
SELECT FLOOR(25);❮ MySQL Functions