删除数据库重复记录

第一种方式：

delete from table_1 where rowid in(    select rid from    (      select         column_1, column_2, column_3,         row_number() over (partition by column_1, column_2, column_3 order by rowid) rno,        rowid rid       from table_1     )    where rno>1)

第二种方式：

delete from ct_busi_reg where rowid not in 　　(select max(rowid) from ct_busi_reg group by login_accept, busi_code, state)