Finding Duplicates with SQL
-- this is awesome testimg
SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING ( COUNT(email) > 1 )
📇 Additional Metadata
- 🗂 Type::#type/snippet
- 🏷️ Tags:: T-SQL
- 📡 Status::#status/🌲
Search
Apr 30, 2024, 1 min read
-- this is awesome testimg
SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING ( COUNT(email) > 1 )