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

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