FLOOR()
It converts the number (argument) into the nearest whole number that is less than or equal to the given number.
Syntax:
FLOOR(number)
Example:
SELECT FLOOR(4.8) AS Result;
Output:
4
TUTORIAL INDEX
- MySQL Tutorial
- Introduction to MySQL
- MySQL History
- Key Features of Mysql
- MySQL Data Types
- MySQL Data Type Categories
- MySQL Numeric Data Type
- MySQL String Data Type
- MySQL Date and Time Data Type
- MySQL Boolean Data Type
- MySQL ENUM Data Type
- MySQL SET Data Type
- MySQL JSON Data Type
- MySQL Spatial Data Types
- MySQL CREATE DATABASE
- MySQL USE Database
- MySQL SHOW DATABASES
- MySQL DROP DATABASE
- MySQL CREATE TABLE
- MySQL SHOW TABLES
- MySQL DESC
- MySQL Table Structure (DESC)
- MySQL SELECT Specific Columns
- MySQL SELECT All Data
- MySQL TRUNCATE TABLE
- MySQL UPDATE
- MySQL DELETE
- SQL Schema
- MySQL Constraints
- Primary Key Constraint
- Foreign Key Constraint
- UNIQUE Constraint
- NOT NULL Constraint
- CHECK Constraint
- DEFAULT Constraint
- Joins: Definition and Types
- INNER JOIN: Retrieve Common Records
- LEFT JOIN: Retrieve Unmatched Right Table Records
- RIGHT JOIN: Retrieve Unmatched Left Table Records
- FULL JOIN: Retrieve Data from Both Tables
- SELF JOIN: Compare Data Within Same Table
- CROSS JOIN: Cartesian Product of Tables
- MySQL Functions: Definition and Types
- String Functions: Types and Uses
- MySQL CONCAT()
- MySQL LENGTH()
- MySQL SUBSTRING()
- MySQL REPLACE()
- Numeric Functions: Types and Their Uses
- MySQL ROUND()
- MySQL CEIL()
- MySQL FLOOR()
- Date and Time Functions: Types and Their Uses
- MySQL NOW()
- MySQL CURDATE()
- MySQL DATEDIFF()
- MySQL TIMESTAMPDIFF()
- Aggregate Functions: Types and Their Uses
- MySQL COUNT()
- MySQL SUM()
- MySQL AVG()
- MySQL MIN()
- MySQL MAX()
- Subquery
- EXISTS Operator
- CASE Statement
- NOT EXISTS Operator
- CTE (Common Table Expression)
- Recursive Queries
- Window Function
- Index Command
- Types of Index in MySQL
- PRIMARY INDEX
- UNIQUE INDEX
- FULLTEXT INDEX
- SPATIAL INDEX
- CREATE INDEX
- DROP INDEX
- EXPLAIN Statement
- Optimizing Queries and Joins in MySQL: Best Practices with Examples
ONLINE WEB TOOLS
