对于重复记录,保留一条delete 表 where id not in (select max(id) as id from 表 group by a,b,c)--其中group by的字段列表不包含ID
都删掉 DELETE A FROM AAA A WHERE EXISTS ( SELECT 1 FROM AAA WHERE A=A.A AND B.A.B AND ID<>A.ID )留一条ID最小的DELETE A FROM AAA A WHERE EXISTS ( SELECT 1 FROM AAA WHERE A=A.A AND B.A.B AND ID<A.ID )留一条ID最大的DELETE A FROM AAA A WHERE EXISTS ( SELECT 1 FROM AAA WHERE A=A.A AND B.A.B AND ID>A.ID )
where id not in (select max(id) as id from 表 group by a,b,c)--其中group by的字段列表不包含ID
DELETE A
FROM AAA A
WHERE EXISTS (
SELECT 1 FROM AAA WHERE A=A.A AND B.A.B AND ID<>A.ID
)留一条ID最小的DELETE A
FROM AAA A
WHERE EXISTS (
SELECT 1 FROM AAA WHERE A=A.A AND B.A.B AND ID<A.ID
)留一条ID最大的DELETE A
FROM AAA A
WHERE EXISTS (
SELECT 1 FROM AAA WHERE A=A.A AND B.A.B AND ID>A.ID
)