# Please write a DELETE statement and DO NOT write a SELECT statement.
# Write your MySQL query statement below
delete p1
from Person p1, Person p2
where
p1.email = p2.email and p1.id > p2.id
题解见连接官方解答。
还是很有难度的。有学习到!!
# Please write a DELETE statement and DO NOT write a SELECT statement.
# Write your MySQL query statement below
delete p1
from Person p1, Person p2
where
p1.email = p2.email and p1.id > p2.id
题解见连接官方解答。
还是很有难度的。有学习到!!