Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly
Appearance settings

Commit bfc33cf

Browse filesBrowse files
arfin-parweenarfin-parween
committed
Time: 1957 ms (17.25%), Space: 0B (100.00%) - LeetHub
1 parent d3e53bc commit bfc33cf
Copy full SHA for bfc33cf

File tree

Expand file treeCollapse file tree

1 file changed

+5
-0
lines changed
Open diff view settings
Filter options
Expand file treeCollapse file tree

1 file changed

+5
-0
lines changed
Open diff view settings
Collapse file

‎0196-delete-duplicate-emails/0196-delete-duplicate-emails.sql‎

Copy file name to clipboard
+5Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,5 @@
1+
# Write your MySQL query statement below
2+
delete p1
3+
from person p1, person p2
4+
where p1.email = p2.email
5+
and p1.id > p2.id

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.