How do I find duplicate records?

[Support]

I need to find duplicate records in a table. How can I do that?

[Support]

You would use a query like this to find duplicates of 2 columns:

SELECT col1, col2, COUNT(*) as `Duplicate_Count`, GROUP_CONCAT(PrimaryKeyCol) as `IDs`
FROM table_name
GROUP BY col1, col2
HAVING COUNT(*) > 1

This would give you a list of duplicates, the number of duplicates, and the IDs of the duplicate records.

[Support]

Extra key words below to make finding this post easier:

finding duplicates

deduplication

SELECT INTO errors