Delete duplicate Records in SQL server
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.