=======================批量删除，只留前十条数据。
delete from THIRD_PARTY_MERCHANT a where a.rowid in ( select rowid from THIRD_PARTY_MERCHANT minus select rowid from THIRD_PARTY_MERCHANT where rownum <10 )
本文共 246 字，大约阅读时间需要 1 分钟。
=======================批量删除，只留前十条数据。
delete from THIRD_PARTY_MERCHANT a where a.rowid in ( select rowid from THIRD_PARTY_MERCHANT minus select rowid from THIRD_PARTY_MERCHANT where rownum <10 )
转载于:https://www.cnblogs.com/21heshang/p/6269218.html