筛选重复数据
select * from 表名 where rowid not in (select min(rowid) from 表名 group by 重复判断字段)
删除重复数据
delete from 表名 where rowid not in (select min(rowid) from 表名 group by 重复判断字段)
2023-11-01 19:43:16
select * from 表名 where rowid not in (select min(rowid) from 表名 group by 重复判断字段)
delete from 表名 where rowid not in (select min(rowid) from 表名 group by 重复判断字段)