Find duplicate rows in a MySQL table

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