How to find duplicate records in an Oracle table

35 pts.
Tags:
Oracle
Oracle Table
How do I find duplicate records in a table?


Software/Hardware used:
oracle

Answer Wiki

Thanks. We'll let you know when a new response is added.

Take a look at this similar question: Delete duplicate record from Oracle table.
Also, you asked almost the same question in 2008. Here is the link to your first question.

You can use the search feature of the site as well.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Brijesh
    select criteria field,count(*) from table name group by criteria field having count(*) > 1
    14,420 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: