oracle多表分页sql语句

最新推荐文章于 2021-09-15 11:37:31 发布

iteye_4709

最新推荐文章于 2021-09-15 11:37:31 发布

阅读量453

点赞数 1

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

本文链接：https://blog.csdn.net/iteye_4709/article/details/82482307

版权

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

1 篇文章 0 订阅

订阅专栏


页数 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