PeterErhard
asked on
Identifying Duplicates
I have an Invoicing table containing the following sub-set of fields:
InvoiceID (PK)
SupplierID
InvoiceNumber
InvoiceDate
InvoiceAmount
Within the table, there are many duplicate records where the SupplierID, InvoiceNumber,InvoiceDate, InvoiceAmount are the same. There could be one duplicate or in some cases more than one duplicate.
I want to delete all but one of any identified duplicates. How could this be done?
InvoiceID (PK)
SupplierID
InvoiceNumber
InvoiceDate
InvoiceAmount
Within the table, there are many duplicate records where the SupplierID, InvoiceNumber,InvoiceDate,
I want to delete all but one of any identified duplicates. How could this be done?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.