SQL PHP HTML ASP JavaScript articles and free scripts to download
SQL Math Functions

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


Thanks for your kind work
Post Comment This is for short comments only. Use the forum for more discussions.
Email( not to be displayed)Privacy Policy

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

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