You have to write a query to identify duplicates and delete them. The syntax depends on the database system you are using. Typically you compare columns that should uniquely identify a record and pick one of the duplicate as delete candidate based on some additional criteria such as timestamp.