delete from t_productbilldetailvods nologging where detailbillid in (select detailbillid from t_productbilldetailvods group by detailbillid having count(detailbillid) > 1) and rowid not in (select min(rowid) from t_productbilldetailvods group by detailbillid having count(detailbillid) > 1);
oracle 删除重复行
最新推荐文章于 2023-02-06 17:15:13 发布