select id,name from (select id,name from tablename) where id not in ((select id from (select id,name from tablename order by id desc ) where rownum <= 20 )) and rownum <= 10
这个id应该是唯一的,最好用时间类型的字段
select id,name from (select id,name from tablename) where id not in ((select id from (select id,name from tablename order by id desc ) where rownum <= 20 )) and rownum <= 10
这个id应该是唯一的,最好用时间类型的字段