pageNo: 展示的页码
pageSize: 展示的条数
mysql的分页:
select *
from a
limit (pageNo - 1) * pageSize, pageSzie;
oracle分页:
select *
from
select rownum rn,*
from a
where rownum <= pageNo * pageSize
)
where rn > (pageNo - 1) * pageSze;
pageNo: 展示的页码
pageSize: 展示的条数
mysql的分页:
select *
from a
limit (pageNo - 1) * pageSize, pageSzie;
oracle分页:
select *
from
select rownum rn,*
from a
where rownum <= pageNo * pageSize
)
where rn > (pageNo - 1) * pageSze;