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.

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

Number of User Comments : 1


Google+

kathir07-06-2012
Thanks for your kind work

Post Comment This is for short comments only. Use the forum for more discussions.






OPINION POLL

What is the most important factor of a web site

HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2015 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer