Skip to main content
  1. Problem Solving Solutions/

Delete Duplicate Emails LeetCode Solution

·1 min
leetcode SQL
Mayukh Datta
Author
Mayukh Datta
Table of Contents

Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id.

+—-+——————+ | Id | Email | +—-+——————+ | 1 | [email protected] | | 2 | [email protected] | | 3 | [email protected] | +—-+——————+ Id is the primary key column for this table.

For example, after running your query, the above Person table should have the following rows:

+—-+——————+ | Id | Email | +—-+——————+ | 1 | [email protected] | | 2 | [email protected] | +—-+——————+

Note:

Your output is the whole Person table after executing your sql. Use delete statement.

Link: https://leetcode.com/problems/delete-duplicate-emails/

MySQL Solution #

delete A from Person A, Person B where A.Email = B.Email and A.Id > B.Id;