本文介绍了一种使用SQL语句来删除指定表中基于特定字段存在的重复记录的方法。通过子查询和分组函数来找出存在重复的数据，并利用这些信息进一步从原始表中移除多余的条目。
delete from table_name where we_id not in
(
select mid from (
select min(we_id) as mid from table_name group by fail_reason HAVING count(*) > 1
) k
)
and fail_reason in
(
select fail_reason from (
select fail_reason from table_name group by fail_reason HAVING count(*) > 1
) k1
);
(
select mid from (
select min(we_id) as mid from table_name group by fail_reason HAVING count(*) > 1
) k
)
and fail_reason in
(
select fail_reason from (
select fail_reason from table_name group by fail_reason HAVING count(*) > 1
) k1
);
扫一扫
1006
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
