floor ceil functions
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.
We can use ceil function to our student table where we will calculate the average mark of the students.
Output = 74.6571 Now we can use ceil command like this.
Output = 75
This article is written by plus2net.com team. https://www.plus2net.com
▼ More on Math functions in SQL