MySQL中的基本分页:
select
ename
from
emp
where xxxxx
order by
sal desc
limit
(pageno-1)*pageSize,pageSize;
Oracle中的基本分页
select tt.*
from (
select t.*,rownum as linenum
from
(select * from tbl_role) t
where
rownum <#{0}*#{1}
)tt
where
linenum >(#{0}-1)*#{1}
原文：http://www.cnblogs.com/KYKY22/p/5794091.html