# 查询要删除的数据SELECT
id
FROM
t_user_tag
WHERE
id NOTIN(SELECT
a.id
FROM(SELECTmax( id ) id FROM t_user_tag GROUPBY user_id, tag_id HAVINGcount(*)>1) a
)AND( user_id, tag_id )IN(SELECT
t.user_id,
t.tag_id
FROM(SELECT user_id, tag_id FROM t_user_tag GROUPBY user_id, tag_id HAVINGcount(*)>1) t
);## 删除并保留一条DELETEFROM
t_user_tag
WHERE
id NOTIN(SELECT
a.id
FROM(SELECTmax( id ) id FROM t_user_tag GROUPBY user_id, tag_id HAVINGcount(*)>1) a
)AND( user_id, tag_id )IN(SELECT
t.user_id,
t.tag_id
FROM(SELECT user_id, tag_id FROM t_user_tag GROUPBY user_id, tag_id HAVINGcount(*)>1) t )