【MySQL】去重

【MySQL】去重

DELETE FROM xxx WHERE id NOT in(
SELECT tmp.id FROM(SELECT id,COUNT(id) AS cnt FROM xxx GROUP BY ticket_id,ota_id HAVING cnt>1)tmp
UNION ALL 
SELECT tmp2.id FROM (SELECT id,COUNT(id) AS cnt FROM xxx GROUP BY ticket_id,ota_id HAVING cnt=1)tmp2)

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/flydkPocketMagic/p/7447119.html