MySQL Duplicate Records Revision as of Tuesday, 13 January 2026 at 18:47 UTC

SELECT      column, COUNT(column) AS column_count 
FROM        table
GROUP BY    column
HAVING      (COUNT(column) > 1)