Skip to content
Programming101
Programming101

Learn everything about programming

  • Home
  • CS Subjects
    • IoT – Internet of Things
    • Digital Communication
    • Human Values
  • Programming Tutorials
    • C Programming
    • Data structures and Algorithms
    • 100+ Java Programs
    • 100+ C Programs
  • HackerRank Solutions
    • HackerRank Algorithms Solutions
    • HackerRank C problems solutions
    • HackerRank C++ problems solutions
    • HackerRank Java problems solutions
    • HackerRank Python problems solutions
Programming101
Programming101

Learn everything about programming

Leetcode Delete Duplicate Emails problem solution

YASH PAL, 31 July 2024

In this Leetcode Delete Duplicate Emails problem solution we need to write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id.

Leetcode Delete Duplicate Emails problem solution

First Problem solution.

delete from Person
where Id in (select r.Id from  
             (select Id, row_number() over(partition by Email 
                                          order by Id
                                         ) as rk
             from Person) r
            where r.rk > 1
            );

Second Problem solution.

DELETE b
FROM Person a, Person b
WHERE a.Email = b.Email
AND a.Id < b.Id;

Third Problem solution.

delete from Person
where Id not in
(select mid from (select min(Id) as mid from Person
group by Email)T )

coding problems

Post navigation

Previous post
Next post
  • HackerRank Separate the Numbers solution
  • How AI Is Revolutionizing Personalized Learning in Schools
  • GTA 5 is the Game of the Year for 2024 and 2025
  • Hackerrank Day 5 loops 30 days of code solution
  • Hackerrank Day 6 Lets Review 30 days of code solution
How to download udemy paid courses for free

Pages

  • About US
  • Contact US
  • Privacy Policy

Programing Practice

  • C Programs
  • java Programs

HackerRank Solutions

  • C
  • C++
  • Java
  • Python
  • Algorithm

Other

  • Leetcode Solutions
  • Interview Preparation

Programming Tutorials

  • DSA
  • C

CS Subjects

  • Digital Communication
  • Human Values
  • Internet Of Things
©2025 Programming101 | WordPress Theme by SuperbThemes