Link to home
Start Free TrialLog in
Avatar of PeterErhard
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?
SOLUTION
Avatar of Barry Cunney
Barry Cunney
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial