Following query would identify the duplicate rows on a table using self join using rowid among duplicates. For faster execution, this is suggested to use unique/primary key values in select and in joinings. If there is no PK/Unique key then its safe to specify all the columns associated with table in joining.
1. Identify Duplicates
2. Delete Duplicates
See the output, do some manual verification and go for deletion with following query.
1. Identify duplicates.
2. 2258 duplicates exist – these can be deleted with command below -