3
Answers

Delete duplicate Records in SQL server

Jitendra Patel

Jitendra Patel

14y
5.6k
1
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)