oracle多表分页sql语句

iteye_4709

于 2013-03-14 17:04:48 发布

阅读量490

点赞数 1

分类专栏： oracle 多表分页sql 文章标签：数据库

本文链接：https://blog.youkuaiyun.com/iteye_4709/article/details/82482307

版权

oracle 多表分页sql 专栏收录该内容

1 篇文章

订阅专栏


页数 currentPage
条数 pageSize
String sql = " SELECT * FROM " +
        			"(SELECT ROWNUM  NUM,t1.* 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.mc  " +
        			"from Nzjyzt a ,Nzsp b ,Nzghs c where a.nbxh = b.nbxh and b.nbxh = c.nbxh and a.nbxh=c.nbxh) t1 " +
        			"WHERE 1=1 AND ROWNUM<=('"+currentPage+"'*'"+numPerPage+"') ) WHERE NUM>('"+currentPage+"'-1)*'"+numPerPage+"' ";


SELECT * FROM   
(SELECT ROWNUM  NUM,NZJYZT.* FROM NZJYZT WHERE 1=1 AND ROWNUM<=(3*20) )  
WHERE NUM>(3-1)*20 

http://abstractforever.iteye.com/blog/606827