第一种方式:
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)