SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calculating average of non-zero values only

658364Feb 11 2010 — edited Feb 11 2010

Hi all,

I have a table containing a numeric column which contains processing time in mili seconds. this can range from zero to any value. I want to calculate average processing time for only those entries which have non zero processing time in a single SQL. can you please suggest any SQL function for this?

I'm using Oracle 10g.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 11 2010

Added on Feb 11 2010

5 comments

6,412 views