SqLite根据某一字段查询并删除(只保留一条)数据表中的重复数据记录

SqLite根据某一个字段查询数据表中重复数据记录的SQL语句如下：

SELECT Url,COUNT(Url) AS C FROM Site GROUP BY Url HAVING COUNT(Url)>1 ORDER BY COUNT(Url) DESC

SqLite根据某一个字段删除数据表中重复数据记录的SQL语句如下：

delete from Site where id not in (select min(id) from Site group  by Url);