To find duplicates, use a query similar to the following:
Select * from TABLE1 a where id ( select max(id) from TABLE1 b where a.Field=b.Field);
Visit the DevX Tip Bank