c# 表数据去重处理

 #region 去重处理
        static public void Distinct(string tableName)
        {
            string sqlCmd= "  delete from tdly." + tableName +
                             "  where rowid in (select rid from(select rowid rid, row_number() " +
                             "  over(partition by "+ getTablePrimeKey(tableName)+ " order by rowid)" +
                             "  rn from tdly." + tableName +" ) where rn<> 1 ) ";
            Tool.WriteLogToFile("去重处理  sql:" + sqlCmd);
            if (Tool.ExecuteNonQuery(sqlCmd, strCnn) < 0)
            {
                Tool.WriteLogToFile("去重表" + tableName + "失败！");
            }
            else
            {
                Tool.WriteLogToFile("去重表" + tableName + "成功！");
            }
        }
        #endregion