SELECT id from AAF_USER where rownum < 1000
DELETE FROM AAF_USER where id not in (SELECT id from AAF_USER where rownum < 1000)
oracle中rownum的基本用法
https://www.cnblogs.com/songhengchao/p/8996255.html
SELECT id from AAF_USER where rownum < 1000
DELETE FROM AAF_USER where id not in (SELECT id from AAF_USER where rownum < 1000)
https://www.cnblogs.com/songhengchao/p/8996255.html