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.

plus2net.com

▼ More on Math functions in SQL

kathir	07-06-2012
Thanks for your kind work

SQL Popular Tutorials

Order by displaying records Records Between two date ranges Some of the records by LIMIT query SQL SUM of data in columns

✖

We use cookies to improve your browsing experience. . Learn more

HTML

MySQL

PHP

JavaScript

ASP

Photoshop

Articles

FORUM . Contact us