delete from table_name a where rowid < (select max(rowid) from table_name b where a.col1 = b.col1 and a.col2 = b.col2 -- 遍历所以数据，以确定重复纪录 )
posted on 2013-12-21 00:12 王小航 阅读(182) 评论(0) 编辑 收藏 举报
