oracle多表分页sql语句
页数 currentPage条数 pageSizeselect * from (select rownum as r,a.qymc,a.zch,b.splb,b.spmc,b.spsb,b.sccj,b.bcqymc,b.bcsb,b.ggxh,b.scrqpc,c.mcfrom Nzjyzt a ,Nzsp b ,Nzghs c where a.nbxh = b.nbxh and b.nbxh = c.nbxh and a.nbxh=c.nbxh)t where rownum<= currentPage*pageSize and rownum<= （currentPage+1）*pageSizeselect * from (select rownum as r,u.userid,u.userid,u.loginName,t.content from userinfo u,twitter t where u.userid=t.userid and loginname like '%java%')t where rownum<= currentPage*pageSize and rownum<= （currentPage+1）*pageSize
