删除oracle部分数据

delete from QYTSCYJD_GXJSCYH_STGTB100187 where rowid not in (select rowid from QYTSCYJD_GXJSCYH_STGTB100187 where rownum<=5);

 

posted @ 2020-11-28 20:02  博二爷  阅读(205)  评论(0编辑  收藏  举报