Murray Brown
asked on
VB.net SQL Deleting duplicates
Hi
In my VB.net project I pull the data shown below into a DataGridView using the following SQL statement.
It shows all records with the same Article and Site combination. How do I delete all duplicates leaving one record
containing the combination
select rtrim([Article])+rtrim([Si te]),count (*) As Count_Duplicates from [MARC] group by rtrim([Article])+rtrim([Si te]) having count(*)>1
In my VB.net project I pull the data shown below into a DataGridView using the following SQL statement.
It shows all records with the same Article and Site combination. How do I delete all duplicates leaving one record
containing the combination
select rtrim([Article])+rtrim([Si
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
ASKER