这道题比较简单，其实是直接考查DELETE指令，我们要达到题目所要求，只需要对其限定两个条件即可，将这个表使用两次，删除两个表中重复并且table1.Id>table2.Id的行即可。
需要注意的是，我们在DELETE指令之后需要指定表名，这里确保删除的是Id大的那个。
关于DELETE指令可以参考：MySQL之创建表格，数据的插入，更新与删除
# Write your MySQL query statement below
DELETE p2 FROM Person p1, Person p2 WHERE p1.Email = p2.Email AND p1.Id < p2.Id;
196. Delete Duplicate Emails Description Write a SQL quer...
题目：196. Delete Duplicate Emails Write a SQL query to dele...
题目链接： 196. Delete Duplicate Emails 解析： 这道题比较简单，其实是直接考查DEL...
Write a SQL query to delete all duplicate email entries i...
Delete Duplicate Emails Rising Temperature
[https://leetcode.com/problems/delete-duplicate-emails/]M...
LeetCode196. Delete Duplicate Emails 题目 Write a SQL query...
原题leetcode,数据库常用操作去重，思路就是按照email列相同合并后（其实这时候已经去重了）取出ID，从p...
ProblemWrite a SQL query to delete all duplicate email en...
D80 182. Duplicate Emails 题目链接 182. Duplicate Emails 题目分析...
本文标题：196. Delete Duplicate Emails
本文链接：https://www.haomeiwen.com/subject/dgzopftx.html
网友评论