摘要：1.筛选重复的记录 http://stackoverflow.com/questions/8190541/deleting-duplicate-rows-from-sqlite-database select s.*,t.[count]from filelist as sinner join (se 阅读全文

摘要：举例1 有一张项目表 CREATE TABLE [ProjectTable] ( [ProjectID] NVARCHAR(16) NOT NULL, [ProjectName] NVARCHAR(20) NOT NULL ON CONFLICT REPLACE DEFAULT Null, [Dev 阅读全文