SQL SERVER FLOOR FORMULA

SQL SERVER FLOOR FORMULA

-- THIS FINDS THE LOWEST WHOLE CLOSEST INTEGER TO A DECIMAL NUMBER FOR EXAMPLE

-- THEORY

-- SELECT FLOOR(ENTER DECIMAL NUMBER)

-- EXAMPLE

SELECT FLOOR(24.79);

-- THE VALUE IS 24