solve problem Delete Duplicate Emails

P-ppc · P-ppc · commit f778823892ab · 2018-11-22T01:06:07.000+08:00
diff --git a/README.md b/README.md
@@ -324,4 +324,5 @@ All solutions will be accepted!
 |596|[Big Countries](https://leetcode-cn.com/problems/big-countries/description/)|[mysql](./database/BigCountries)|Easy|
 |182|[Duplicate Emails](https://leetcode-cn.com/problems/duplicate-emails/description/)|[mysql](./database/DuplicateEmails)|Easy|
 |596|[Classes More Than 5 Students](https://leetcode-cn.com/problems/classes-more-than-5-students/description/)|[mysql](./ClassesMoreThan5Students)|Easy|
-|620|[Not Boring Movies](https://leetcode-cn.com/problems/not-boring-movies/description/)|[mysql](./database/NotBoringMovies)|Easy|
+|620|[Not Boring Movies](https://leetcode-cn.com/problems/not-boring-movies/description/)|[mysql](./database/NotBoringMovies)|Easy|
+|196|[Delete Duplicate Emails](https://leetcode-cn.com/problems/delete-duplicate-emails/description/)|[mysql](./database/DeleteDuplicateEmails)|Easy|
diff --git a/database/DeleteDuplicateEmails/README.md b/database/DeleteDuplicateEmails/README.md
@@ -0,0 +1,2 @@
+# Delete Duplicate Emails
+We can solve this problem by GROUP BY and temp table
diff --git a/database/DeleteDuplicateEmails/solution.sql b/database/DeleteDuplicateEmails/solution.sql
@@ -0,0 +1,7 @@
+# Write your MySQL query statement below
+delete from Person where Id not in (
+    select temp.Id from (
+        select min(Id) as Id from Person group by Email
+    ) 
+    as temp
+)

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+# Delete Duplicate Emails`
	`2`	`+We can solve this problem by GROUP BY and temp table`