Oracle table fields to heavy ____oracle

The weight of the word field
View Duplicate data

SELECT * from Testrepeat t where t.id in (select ID from testrepeat GROUP by ID has count (ID) > 1);

Delete duplicate records, keep rowid the smallest rows

Delete from Testrepeat t
 where t.id in (select ID from testrepeat GROUP by ID have count (ID) > 1) and
   rowid n OT in
       (select min (rowid) from Testrepeat GROUP by ID has count (*) > 1)

Multi-field to weight
View Duplicate data

SELECT * from Testrepeat t where (T.id,t.phone) in (select Id,phone to Testrepeat GROUP by Id,phone have count (*) > 1);

Delete duplicate records, keep rowid the smallest rows

Delete from Testrepeat t
 where  (T.id,t.phone) in (select Id,phone to  testrepeat GROUP by Id,phone has COUNT (*) > 1) and
   rowID not in
       (select min (rowid) from Testrepeat GROUP by Id,phone have count (*) > 1)