Find duplicate rows table

Find duplicate rows table

Find duplicate rows in table

If you want find duplicate records from table please use below:

For Table with columns Field1, Field2:

SELECT FIELD1, FIELD2
FROM Table
GROUP BY FIELD1, FIELD2
HAVING COUNT(*)>1

Leave a Reply

Your email address will not be published. Required fields are marked *