删除表中重复行SQL

删除表中重复行SQL

DELETE FROM table_name a
 WHERE ROWID < (SELECT MAX(ROWID)
                  FROM table_name b
                 WHERE a.col1 = b.col1
                   AND a.col2 = b.col2); -- 遍历所以数据，以确定重复纪录