floor ceil functionsWe 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
We can use ceil function to our student table where we will calculate the average mark of the students.
|▼ More on Math functions in SQL|