Fetching algorithms...
Fetching algorithms...
Person table:
| id | |
|---|---|
| 1 | a@b.com |
| 2 | c@d.com |
| 3 | a@b.com |
Result table:
| a@b.com |
In the given Person table, the email 'a@b.com' appears twice (for id 1 and id 3), which makes it a duplicate email. The email 'c@d.com' appears only once (for id 2), so it is not a duplicate. Therefore, the output correctly lists only 'a@b.com' as the duplicate email.