delete from hd_personal_info_bak1 t
where t.rowid in (select rid
from (select t1.rowid rid,
row_number() over(partition by t1.personalid order by 1) rn
from hd_personal_info_bak1 t1) t1
where t1.rn > 1);
hd_personal_info_bak1表明
personalid主键
rowid唯一标识