SQL FLOOR()

The SQL math function FLOOR() returns the largest integer that is less than or equal to a specified numeric value. It effectively rounds down a number to the nearest whole integer.

Syntax

SELECT FLOOR(number)
FROM table_name;

Copy to clipboard
Copy to clipboard

• number - The value which will be floored / rounded down.

Example

In this example, the following data is given, in a table named employees:

The FLOOR() function can be used to return the largest integer that is less than or equal to a given value:

SELECT employee_id, FLOOR(salary) AS floored_salary
FROM employees;

Copy to clipboard
Copy to clipboard

In this SQL statement, the salary values are floored for each employee to get the floored_salary. The AS keyword is used to name the resulting column floored_salary in the output.

The output will be: