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