select sum(count(1))-count(1) from table group by id having count(1)>1
--查询重复行数
select count(1)
from table
where _id in (select _id
from table
group by _id
having count(*) > 1)
and rowid not in
(select min(rowid)
from table
group by _id
having count(*) > 1);
--查询 去重条数
delete from table
where _id in (select _id
from table
group by _id
having count(*) > 1)
and rowid not in
(select min(rowid)
from table
group by _id
having count(*) > 1);
--删除重复数据