[LeetCode][SQL]Delete Duplicate Emails

delete语句里不能再select这个表，这种写法是过不了的。

<span style="color: #0000ff;">delete</span> A <span style="color: #0000ff;">from</span> Person A <span style="color: #0000ff;">where</span> A.Email <span style="color: #808080;">in</span> (<span style="color: #0000ff;">select</span> B.Email <span style="color: #0000ff;">from</span> Person B <span style="color: #0000ff;">group</span> <span style="color: #0000ff;">by</span> B.Email <span style="color: #0000ff;">having</span> <span style="color: #ff00ff;">count</span>(<span style="color: #808080;">*</span>) <span style="color: #808080;">></span> <span style="color: #800000; font-weight: bold;">1</span>)

[LeetCode][SQL]Delete Duplicate Emails

标签：