mysql 数据去重复
2017-08-07 本文已影响0人
投资是件快乐的事
DELETE
FROM `portrait_tc_call_record`
WHERE
detailsId IN (
SELECT cr.detailsId
FROM ( SELECT detailsId
FROM `portrait_tc_call_record`
GROUP BY detailsId,party_id,bill_Month
HAVING COUNT(detailsId) > 1
) cr
)
AND id NOT IN (
SELECT tc.id
FROM ( SELECT MIN(id) id
FROM `portrait_tc_call_record`
GROUP BY detailsId,party_id,bill_Month
HAVING COUNT(detailsId) > 1
) tc
)
