SELECT name, email, COUNT(*) FROM users GROUP BY name, email HAVING COUNT(*) > 1
sql find duplicate
原文：https://www.cnblogs.com/kakaisgood/p/10027920.html
