Oracle之分页查询

select * from ( select a.*, rownum rn 
from (select * from table_name) a where rownum<= 40 ) where rn >= 21
posted @ 2016-12-02 14:56  hh1223837  阅读(115)  评论(0编辑  收藏  举报