How to remove the duplicate records

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • madankarmukta
    Contributor
    • Apr 2008
    • 308

    How to remove the duplicate records

    Anyone can help on , How to remove the duplicate records. Anyone has implemented it ?
  • RonB
    Recognized Expert Contributor
    • Jun 2009
    • 589

    #2
    The best approach would be to not allow duplicates in the first place. That is accomplished by having a properly designed (normalized) database structure using foreign key constraints and is ACID compliant.

    Based on your question, I assume your database isn't properly designed. Since you haven't given any info about your database, it's impossible for anyone to tell you how to remove your unwanted data.

    Comment

    Working...