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 find duplicate records in a table

602082Nov 28 2007 — edited Sep 17 2008

Hi,

I have a table named JE_DESC. The fields it in it are JE_NUMBER,MONTH,ENTITY_REFERENCE and AMOUNT.

I want to find duplicate records with JE_NUMBER,MONTH and ENTITY_REFERENCE combination.

Then i want to find the Sum of Amount in the duplicate fields

Can anyone help me in generating a query for this

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 15 2008

Added on Nov 28 2007

13 comments

99,302 views