×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Find Duplicates in Your Table
 

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);
Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved