sql find duplicate
SELECT GUID, COUNT(*) FROM xx GROUP BY GUID HAVING COUNT(*) > 1;
SELECT name, email, COUNT(*) FROM users GROUP BY name, email HAVING COUNT(*) > 1
SELECT GUID, COUNT(*) FROM xx GROUP BY GUID HAVING COUNT(*) > 1;
SELECT name, email, COUNT(*) FROM users GROUP BY name, email HAVING COUNT(*) > 1