- 题目描述
- 解法代码
DELETE FROM Person
WHERE Id
IN (
SELECT a.Id FROM
(
SELECT P1.Id
FROM Person AS P1,Person AS P2
WHERE P1.Id>P2.Id AND P1.Email=P2.Email
)
AS a);
- SQL知识点
删除数据-DELETE FROM
DELETE FROM Person
WHERE Id
IN (
SELECT a.Id FROM
(
SELECT P1.Id
FROM Person AS P1,Person AS P2
WHERE P1.Id>P2.Id AND P1.Email=P2.Email
)
AS a);