🏠 Home
Benchmark Hub
📊 All Benchmarks 🦖 Dinosaur v1 🦖 Dinosaur v2 ✅ To-Do List Applications 🎨 Creative Free Pages 🎯 FSACB - Ultimate Showcase 🌍 Translation Benchmark
Models
🏆 Top 10 Models 🆓 Free Models 📋 All Models ⚙️ Kilo Code
Resources
💬 Prompts Library 📖 AI Glossary 🔗 Useful Links
Intermediate

Identify Duplicate Records

#sql #database #data-cleaning

Generate a SQL query to find duplicate entries in a table.

Write a SQL query for a table named 'users' with columns 'id', 'email', and 'name'. The query should identify all email addresses that appear more than once in the table, displaying the email and the count of occurrences.