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);