developer-roadmap/roadmaps/sql/content/floor@o2SH4iQn1Ap2yDZ7cVYLO.md

FLOOR

FLOOR is a numeric function that returns the largest integer value that is less than or equal to a given number. Effectively, it rounds a number down to the nearest whole number. For instance, FLOOR(7.9) would return 7, and FLOOR(-7.1) would return -8.

Visit the following resources to learn more:

• @video@How to Round in SQL