How to Delete duplicate enteries in your table

How to Delete duplicate enteries in your table 


If there are lot of records which are duplicate and you want to delete then you can use this query. Lets EmpId is column to determine duplicate then use this query.

delete from table where rowid not in(select min(rowid) from table group by EmpId);


I hope it will help you.

Comments