How To: Delete Duplicate Rows from a Table
Posted on: August 15, 2009
- In: SQL | SQL Server
- 2 Comments
Problem: You have a table (table1) & values as above, and it contains the duplicate records as shown, how will you delete the duplicates?
Solution: Use following query, the records shown in the below image will be deleted
delete from table1 where empid not in(select max(empid) from table1 group by empName,empEmail,empCity);
Advertisements
2 Responses to "How To: Delete Duplicate Rows from a Table"
October 2, 2009 at 7:09 pm
Hi Ram,If you dont have primary key column in your table, alter the table define a primary key column, delete it duplicate and again alter the table and remove the primary key column.Thanks 🙂
October 2, 2009 at 7:06 pm
hi kiran,1. the scenario is wrongwe find the employee id as different this is unique rows so not duplicate rows2. review the query