python内对sqlite3数据库表删除某几列相同的行index

方法一：
【SQL语言：筛选符合给定几列的值相同的行】
SELECT * FROM quote_ashares_stock_fund_index WHERE rowid NOT IN (SELECT MIN(rowid) FROM quote_ashares_stock_fund_index GROUP BY date, code);
返回所有重复的行，
或者，
SELECT date, code, COUNT() FROM quote_ashares_stock_fund_index GROUP BY date, code HAVING COUNT() > 1;
例如 返回的列只有 id,date,code,count=重复次数，2次就是2

        删除符合给定几列的值相同的行
        DELETE FROM quote_ashares_stock_fund_index WHERE rowid NOT IN (SELECT MIN(rowid) FROM quote_ashares_stock_fund_index GROUP BY date, code);

【对应python代码：】
str_sql = “delect from " +table_name+” where rowid not in (select min(id) from " +table_name
str_sql = str_sql + " group by " + str_list + " )"
print(“str_sql \n”,str_sql )
temp_data = self.cursor.execute( str_sql ).fetchall()
### 获取列信息 || https://blog.csdn.net/qq_4179