delete from table_name a where rowid <
(select max(rowid) from table_name b
where a.col1 = b.col1
and a.col2 = b.col2 -- 遍历所以数据,以确定重复纪录
)
删除表中重复行SQL
最新推荐文章于 2024-09-06 22:15:10 发布
delete from table_name a where rowid <
(select max(rowid) from table_name b
where a.col1 = b.col1
and a.col2 = b.col2 -- 遍历所以数据,以确定重复纪录
)