sqlite常见操作收集

如何查找出sqlite数据库中重复的字段

重复的字有哪些

select * from table_name  group by key having count(key)>1;

重复的字有哪些，包括重复的信息

select * from table_name where key in
(
select key from table_namegroup by key having count(key )>1
)
order by key asc