1、查询出重复记录形成一个新的临时表t,临时表里是每种重复记录的最新id
(SELECT
MIN(id),
user_id,
user_name
FROM
A
GROUP BY
user_id,
user_name
HAVING
COUNT(*) > 1
) t
2、关联判断重复基准的字段
A.user_id = t.user_id
A.user_name = t.user_name
3、根据条件,删除原表中id大于t表中id的记录
1、查询出重复记录形成一个新的临时表t,临时表里是每种重复记录的最新id
(SELECT
MIN(id),
user_id,
user_name
FROM
A
GROUP BY
user_id,
user_name
HAVING
COUNT(*) > 1
) t
2、关联判断重复基准的字段
A.user_id = t.user_id
A.user_name = t.user_name
3、根据条件,删除原表中id大于t表中id的记录