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