Skip to Main Content
Forums

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!

How to use AVG function to determine difference.

690975Mar 15 2009 — edited Mar 19 2009
Hi, I have a basic table where there is an invoice price. I can do the AVG function to find out what the average is, but I need to be able to subtract the difference from each value in the column and submit it as a query. I was wondering if anyone had any advice how I'd do that.

Thanks,

Justin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2009
Added on Mar 15 2009
5 comments
247 views