The Problem: You have duplicate rows in a table and you need to identify them immediately.
The Fix: Use GROUP BY and HAVING to isolate records appearing more than once.
SELECT Email, COUNT(*) as Count FROM Users GROUP BY Email HAVING COUNT(*) > 1;