devxlogo

May 24, 2018

Find Duplicates in Your Table

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