floor math function in MySQL to get higher integer value from numeric data

SELECT FLOOR(80.41); => 80

Floor MySQL function returns the highest integer which is lower than the input value. This can be easily understood by some examples.

select floor(5.89)  => 5
select floor(5.22)   =>5
select floor(-5.89)   =>-6
select floor(-5.12)   =>-6

As you can see in above command gives highest integer which is lower than the input value.

We will apply our floor command to our student table. We will take average ( avg ) value of all marks secured by students and to that we will apply floor command. Let us first try without floor.

SELECT avg(mark) as avg FROM `student`

Output = 74.6571

Now we can use floor command like this.

SELECT floor(avg(mark)) as avg FROM `student`

Output = 74
SQL Math References CEIL function to get lowest integer value Average value Query

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

kathir	07-06-2012
Thanks for your kind work

floor() : Highest integer lower that the input

Subhendu Mohapatra