Find Duplicate Emails
Find Duplicate Emails
EasySQL0% accepted
Given a Person table with Id and Email columns, write a SQL query to find all duplicate emails (emails that appear more than once).
Approach
Find duplicate emails using GROUP BY and HAVING COUNT.
Input
Output
More SQL problems
Browse all coding problems →Scenarios & Expected Answers
Sign in to continue
Create a free account to view answers and mark progress.
- Free forever — no credit card
- Theory Q&A with detailed answers
- Points, streaks & leaderboards