删除表中重复数据，并且数据不完全相同

上代码：用表筛选出要删除的id

DELETE
FROM
t_reply_agree
WHERE
id IN (
SELECT
a.id
FROM
( SELECT MIN( id ) AS id FROM t_reply_agree WHERE is_del = 0 GROUP BY reply_id, user_id HAVING COUNT( * )> 1 ) a
)