=======================批量删除,只留前十条数据。
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 )
=======================批量删除,只留前十条数据。
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 )