Fetching algorithms...
Fetching algorithms...
Person table:
| id | |
|---|---|
| 1 | john@example.com |
| 2 | bob@example.com |
| 3 | john@example.com |
| id | |
|---|---|
| 1 | john@example.com |
| 2 | bob@example.com |
The email 'john@example.com' appears twice, with id=1 and id=3. According to the problem statement, we must keep the entry with the smallest id for this email, which is id=1. Therefore, the row with id=3 and email 'john@example.com' is deleted. The email 'bob@example.com' appears only once with id=2, so it is kept as is. The final table contains the unique emails with their respective smallest IDs.