ROUND, CEIL and FLOOR Functions

Rounding Numbers

How Each Works

Example

SELECT ROUND(AVG(marks),2) AS avg2,
       CEIL(AVG(marks)) AS rounded_up,
       FLOOR(AVG(marks)) AS rounded_down
FROM students;

Summary

• ROUND = nearest; CEIL = up; FLOOR = down.

Numbers Rounding

हर एक कैसे काम करता है

Example

SELECT ROUND(AVG(marks),2) AS avg2,
       CEIL(AVG(marks)) AS rounded_up,
       FLOOR(AVG(marks)) AS rounded_down
FROM students;

सारांश

• ROUND = nearest; CEIL = ऊपर; FLOOR = नीचे।