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.
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
Post a Comment
Please avoid link comments