floor math functions
Floor mysql function returns the highest integer which is lower than the input value. This can be easily understood by some examples.
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.
Output = 74.6571
Now we can use floor command like this.
Output = 74