本文介绍了一种使用SQL语句从数据库表中删除重复记录的方法。通过对比两个表的指定字段，找出并删除那些在特定字段上重复的记录，仅保留每组重复记录中的第一条。此方法适用于需要清理数据，确保数据唯一性的场景。
delete from table a
where (a.ziduan_0,a.ziduan_1,a.ziduan_2) in (
select ziduan_0,ziduan_1,ziduan_2from table where ziduan_0!='0' group by ziduan_0,ziduan_1,ziduan_2 having count(*) > 1
)
and rowid not in (
select min(rowid) from table where ziduan_0!='0' group by ziduan_0,ziduan_1,ziduan_2 having count(*)>1
)
扫一扫
628
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
