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

Math functions used in SQL

avg:Getting average of data in MySQL

sum:Sum of a range of data in MySQL

sum of multiple columns in MySQL & to get Percentage and total

min:Getting the Minimum value of data in MySQL

max:Getting the Miximum value of data in MySQL

mod:Getting the reminder of a division by using Mod function

Getting second highest number from the student table

format: Formatting MySQL data in a query while managing records of a table

floor: MySQL function to get highest integer lower than the input value

ceil: MySQL function to get lowest integer higher than the input value

abs: MySQL abs function to get absolute value

round: MySQL round function to get rounded value from column

conv: MySQL conv to convert numbers from one base to other

truncate: MySQL truncate function to remove decimal places

sqrt: square root of number by sqrt function

pow: Power of a number pow function

kathir	07-06-2012
Thanks for your kind work

Queries INSERT UPDATE

Aggregate Queries AVG ( Average ) SUM MIN MAX

SQL Video Tutorials

✖

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

HTML

MySQL

PHP

JavaScript

ASP

Photoshop

Articles

FORUM . Contact us