<--select * from (select t.*,rownum rn from cost t order by cost_id asc)
where rn>=3 and rn<=8;-->
oracle:
select * from (select t.*,rownum rn from db t order by id asc)
where rn>=(pageIndex-1)*pageSize+1 and rn<=pageSize*pageIndex;
mysql:
select * from tableName limit pageIndex,pageSize;
pageIndex:页码
pageSize:每页记录数