Oracle之分页查询

select * from ( select a.*, rownum rn 
from (select * from table_name) a where rownum<= 40 ) where rn >= 21
原文地址:https://www.cnblogs.com/huhuan123/p/6125791.html