How to Find Duplicate Rows in MySQL

Last updated July 25, 2026 · By the SaturnSQL team

GROUP BY the columns that should be unique and keep groups with HAVING COUNT(*) > 1. Join that result back to the table when you need to see the full duplicated rows, not just the keys.

SELECT email, COUNT(*) AS dupes
FROM customers
GROUP BY email
HAVING COUNT(*) > 1;

SELECT c.*
FROM customers c
JOIN (
  SELECT email FROM customers
  GROUP BY email HAVING COUNT(*) > 1
) d ON d.email = c.email
ORDER BY c.email, c.id;