Contact Us
SQL
>
Math Functions
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
floor function
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
Tweet
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
Post Comment
This is for short comments only. Use the
forum
for more discussions.
Name
Email
( not to be displayed)
Privacy Policy
1+2=
This is to prevent automatic submission by spammers. Please enter the result of the sum as asked
Join Our Email List
Email:
For
Email Newsletters
you can trust
SQL Applications
•
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