Below Script will be helpful to remove duplicated records from a table.
DELETE
FROM TABLE_NAME WHERE ROWID IN (SELECT MAX(ROWID) FROM TABLE_NAME WHERE (OPTION_01,OPTION_02) IN (SELECT OPTION_01,OPTION_02 FROM (SELECT OPTION_01,OPTION_02, COUNT(*) FROM TABLE_NAME GROUP BY OPTION_01,OPTION_02 HAVING COUNT(*) > 1 ) ) GROUP BY OPTION_01,OPTION_02 );
Comments
Post a Comment