摘要：//获取excel数据 public DataSet ExecleDs(string filePath) { try { int exc = filePath.LastIndexOf('.'); string excelType = filePath.Substring(exc, filePath.Length - exc); string strConn = ""; if (excelType == "... 阅读全文

摘要：查找所有重复标题的记录：SELECT *FROM t_info aWHERE ((SELECT COUNT(*)FROM t_infoWHERE Title = a.Title) > 1)ORDER BY Title DESC一。查找重复记录1。查找全部重复记录Select * From 表 Where 重复字段 In (Select 重复字段 From 表 Group By 重复字段 Having Count(*)>1)2。过滤重复记录(只显示一条)Select * From HZT Where ID In (Select Max(ID) From HZT Group By Ti 阅读全文