Practice Duplicate Emails
Read the task, work through the examples, and check your approach against the constraints. Use the original LeetCode task for coding and submissions.
Problem Statement
Tables: Person(id INT, email VARCHAR). Person.id is unique. Emails are non-null and contain no uppercase letters. Report each email value occurring in more than one row, once per duplicated value, in any order. Group by email and retain groups with more than one row.
Source: Duplicate Emails on LeetCode. Use the original task for its coding environment and submissions.
Examples
# Example 1
Input
Person table: +----+---------+ | id | email | +----+---------+ | 1 | a@b.com | | 2 | c@d.com | | 3 | a@b.com | +----+---------+
Output
+---------+ | Email | +---------+ | a@b.com | +---------+
Related LeetCode Problems
Practice more problems similar to Duplicate Emails.
Review your practice with PhantomCodeAI
After trying the problem yourself, use the app to discuss your approach, complexity, and edge cases.