Software Applications Programming Errors and solutions.

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.