删除oracle部分数据

delete from QYTSCYJD_GXJSCYH_STGTB100187 where rowid not in (select rowid from QYTSCYJD_GXJSCYH_STGTB100187 where rownum<=5);
原文地址:https://www.cnblogs.com/smartisn/p/14053834.html