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