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
(*) As Count_Duplicates from [MARC] group by rtrim([Article])+rtrim([Si
te]) having count(*)>1