W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

Nov 24, 2025 · FLOOR returns the largest integer less than or equal to the specified numeric expression.

This tutorial shows you how to use the SQL FLOOR() function to return the largest integer less than or equal to the specified number.

Sep 29, 2020 · SELECT FLOOR(21.53); Output : 21 Example-2 : When the argument holds a negative number. SELECT FLOOR(-21.53); Output : -22 2. CEILING () Function : The CEILING () function …

For example, the floor of 5 is 5 itself, while the floor of 5.1 is also 5. As another example, the floor of 4.9 is 4. In SQL, we use the FLOOR function. It takes the number to round and returns the nearest …

Learn how to use the SQL Server FLOOR() function to round a number down to the nearest integer that is less than or equal to the input value.

Feb 26, 2026 · SQL FLOOR() function: SQL FLOOR()function rounded up any positive decimal value down to the next least integer value.

SQL is a standard language for storing, manipulating and retrieving data in databases. Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, PostgreSQL, and other …

The FLOOR function is a precise and efficient tool for rounding numbers down, making your SQL queries more controlled and accurate. From calculating whole units to setting price floors, it’s a key …

Discover how to use the FLOOR () function in SQL with examples, common use cases, and error handling tips to optimize your queries.