Deletion Records of Duplicate

Describes how to use SQL query of remove duplicate records from tables

DELETE FROM T_CONTACTS A 
WHERE A.ROWID > (SELECT MIN (ROWID) FROM T_CONTACTS B WHERE A.PHONE_NO = B.PHONE_NO);