SELECT name, email, COUNT(*) FROM users GROUP BY name, email HAVING COUNT(*) > 1
Finding duplicates with SQL
Reply
Johannes' Blog
Mobile stuff for OSM and kids.
SELECT name, email, COUNT(*) FROM users GROUP BY name, email HAVING COUNT(*) > 1