Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Thursday May 24th 2018 by Hannes du Preez

Language: SQL, Expertise: Beginner - Use a query similar to this one to find duplicates in your tables.

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);
Mobile Site | Full Site