oracle的分页查询

最新推荐文章于 2024-08-19 08:45:16 发布

照片怎么加不上

最新推荐文章于 2024-08-19 08:45:16 发布

阅读量505

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/qq_38788128/article/details/81745046

版权

数据库专栏收录该内容

9 篇文章 0 订阅

订阅专栏

 <select id="queryBigServerList" parameterType="map" resultType="BigServer">
 
 SELECT * FROM (
  
      SELECT ROWNUM rn,l.id,l.bigeyeIP, l.usage,     

        l.activity_label,l.location,l.capacity,l.capacity_threshold FROM ( 
            select * from BIGEYE_CONF 
                          where 1=1
  
                           <if test="bigeyeIP != null and bigeyeIP != ''">
                              and bigeyeIP=#{bigeyeIP}
   
                           </if>
  
                           <if test="usage != null and usage != ''">
                              and usage=#{usage}
   
                           </if>
                           <if test="activity_label != null and activity_label != ''">
   
                              and activity_label=#{activity_label}
                            </if>
     ) l WHERE #{page.endPos} >ROWNUM


) t2 

WHERE T2.rn >=#{page.startPos}
  
  </select>