Oracle删除重复数据, 只留一条数据

1.获取重复的数据; 2, 只保留最小的rowid

delete from apex_qualitymonitordetail a

where  a.barcode 

in (select barcode from apex_qualitymonitordetail d
group by barcode having count(barcode) > 1
    )
and rowid not

in (select min(rowid) from apex_qualitymonitordetail d
group by barcode having count(barcode)>1
 )