ceil math function in MySQL to get smallest integer value from numeric data

SELECT CEIL(5.94);   -- 6
SELECT CEIL(5.24);   -- 6
SELECT CEIL(-5.24);  -- -5
SELECT CEIL(-5.54);  -- -5

We can use MySQL ceil() function to get the smallest integer not less than the input value.

Same way we can use the floor function to get the highest integer which is lower than the input value.

We can use ceil function to our student table where we will calculate the average mark of the students.

SELECT AVG(mark) AS avg_mark FROM student;

Output = 74.6571 Now we can use ceil command like this.

SELECT CEIL(AVG(mark)) AS avg_mark FROM student;

Output = 75

SQL Math References Floor function to get Maximum integer value Average value Query

All Math Functions FLOOR()

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

ceil(): smallest integer not less than the input value

Subhendu Mohapatra