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

This article is written by plus2net.com team.

plus2net.com

▼ More on Math functions in SQL

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