Home >> MySql >> FLOOR() aggregate function in MySql

FLOOR() aggregate function in MySql

FLOOR() find the largest integer value that is equal to or less than a number.

Example

FLOOR(25.8)

25

FLOOR(6.5)

6

Post Your Comment

Next Questions
CEIL() aggregate function
FIRST() aggregate function
LAST() aggregate function
MID() aggregate function
LEN() aggregate function
NOW() aggregate function
FORMAT() aggregate function
COUNT() aggregate function
LOWER() aggregate function
UPPER() aggregate function
INITCAP() aggregate function
SUBSTR() aggregate function
ASCII() aggregate function
LENGTH() aggregate function
TRIM() aggregate function
LTRIM() aggregate function
RTRIM() aggregate function
What is transaction
What is normalization and types of normalization
What is First Normal Form(1NF)
What is Second Normal Form(2NF)
What is Third Normal Form(3NF)
What is Boyce Codd Normal Form(BCNF)
What is Fourth Normal Form(4NF)
What is Fifth Normal Form(5NF)

Copyright ©2022 coderraj.com. All Rights Reserved.