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

floor math functions

SELECT FLOOR(80.41);

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

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com

▼ More on Math functions in SQL

floor math functions

Subscribe