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!

Problem with Distinct Sum

646144Jun 19 2008 — edited Jun 20 2008
Hi all,

I suddently found out a problem.

Firstly, I used SELECT DISTINCT to query my db, which filtered out most of the dupelicated data. Then I will to sum up a column, which only shows the distincted data rows. However, when I use SUM( l.db_waf_qty), it will add up the qty which has been filtered out by distinct, which leads to an incorrect result.

Please kindly help Thanks..

Jon
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2008
Added on Jun 19 2008
7 comments
1,283 views