How to get round up value of and avg number in oracle.

Question

I need to calculate average value and then round it up, can any one tell me, or upvote this

Answer 1

It will only round up value to next decimal value, like 5.76 to 5.8 but instead of this i want answer as "6" which is the next integer value

Answer 2

In Oracle Database:
CEIL(AVG(value))

Use proper tags please, its very confusing what your question is related to.

Answer 3

CEIL returns smallest integer greater than or equal to n.
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions017.htm