Delete duplicate Records in SQL server

May 5 2010 5:54 AM
Hi,

In my table two field and this data.

ID    Name
----------------
1    Test   
2    Example
3    Data
4    information


but after a few days another person has enter 2 records

and table structure are like this.


ID    Name
----------------
1    Test   
2    Example
3    Data
4    information
3    Data
4    information

how to find which records is original records.

and how to delete this duplicte records in table.

Answers (3)