Math Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Math Functions
  4. FLOOR returns the value that represents the largest integer that is less-than or equal to the input_number
The syntax  for the FLOOR  function is as follows: FLOOR(input_number)
9> SELECT 5-2*FLOOR(5/2)
10> GO
-----------
          1
(1 rows affected)
1>