Oracle通用分页

select
*
from
(select
row_.*, rownum rownum_
from
(select XXX from XXX where XXX) row_
where rownum <= X)
where
rownum_ >= X

例: 查找前二十位的学生信息
select
*
from
(select
row_.*, rownum rownum_
from
(select id, name, class from t_student) row_
where rownum <= 20)
where
rownum_ >= 1