Skip to content
Programming101
Programmingoneonone
  • Home
  • CS Subjects
    • Internet of Things (IoT)
    • 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
Programmingoneonone

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 solutions

Post navigation

Previous post
Next post

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
  • YouTube
  • LinkedIn
  • Facebook
  • Pinterest
  • Instagram
©2025 Programmingoneonone | WordPress Theme by SuperbThemes