数据库删除重复记录

 删除重复记录：

SQL> delete from wzh_questions a where a.rowid!=(select max(rowid) from lunar b where a.shuaho=b.shuhao and a.tihao=b.tihao);

整理INSERT语句

select 'insert into wzh_questions150 values('||chr(39)||xuhao||chr(39)||','||chr(39)||shuhao||chr(39)||','||chr(39)||tihao||chr(39)||','||chr(39)||wenti||chr(39)||','||chr(39)||xz1||chr(39)||','||chr(39)||xz2||chr(39)||','||chr(39)||xz3||chr(39)||','||chr(39)||xz4||chr(39)||','||chr(39)||zqxz||chr(39)||','||chr(39)||ywlt||chr(39)||','||chr(39)||ltmc||chr(39)||');' from  wzh_questions100