使用 not in ,不过要两次扫描 select * from t where id not in (select id from t where rownum<=20) and rownum <=10
select * from t where id not in (select id from t where rownum<=20) and rownum <=10
17,082
社区成员
55,236
社区内容
加载中
试试用AI创作助手写篇文章吧