floor ceil functions
We can use mysql ceil function to get the smallest integer which is higher than the input value.
Same way we can use the
to get the highest integer which is lower than the input value.
Here are some examples of ceil function.
select ceil(5.94) => 6
select ceil(5.24) => 6
select ceil(-5.24)=> -5
select ceil(-5.54) => -5
We can use ceil function to our student table where we will calculate the average mark of the students.
SELECT avg(mark) as avg FROM `student`
Output = 74.6571
Now we can use ceil command like this.
SELECT ceil(avg(mark)) as avg FROM `student`
Output = 75
Please rate this Article on one to five scale
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
sign: MySQL sign function to get sign of numbers
conv: MySQL conv to convert numbers from one base to other
oct: MySQL oct to convert numbers from decimal to Octal system
truncate: MySQL truncate function to remove decimal places
sqrt: square root of number by sqrt function
This is for short comments only. Use the
for more discussions.
( not to be displayed)
This is to prevent automatic submission by spammers. Please enter the result of the sum as asked
Join Our Email List
you can trust
SQL Like to search with wildcard
Copy structure or Data from one table to other
SQL Left join to get matching records
Getting highest of Maximum record
Searching for keywords in a table
©2000-2013 plus2net.com All rights reserved worldwide