关键是利用伪列rownum(从1开始计数)进行分页,格式如下:
select * from (select pagination.*,rownum page from (select * from a) pagination where rownum<上限) where page>下限
关键是利用伪列rownum(从1开始计数)进行分页,格式如下:
select * from (select pagination.*,rownum page from (select * from a) pagination where rownum<上限) where page>下限