分页语句

iteye_8996

于 2011-09-20 15:41:55 发布

阅读量134

点赞数

分类专栏： Oracle

本文链接：https://blog.csdn.net/iteye_8996/article/details/82140522

版权

Oracle 专栏收录该内容

8 篇文章

订阅专栏

本文深入探讨了SQL查询在处理复杂数据集时的高级技巧，包括使用子查询、联接、聚合函数等方法来提高查询效率。通过实例演示，展示了如何在实际场景中应用这些技巧，以实现更快速、更精确的数据筛选和解析。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


select columnId,
       type,
       itemType,
       addDate,
       startDate,
       endDate,
       viewCnt,
       status,
       columnName,
       topicIntro,
       topicLogo,
       topicBanner,
       additionalUrl,
       templetId
  from (select rownum rn,
               columnId,
               type,
               itemType,
               addDate,
               startDate,
               endDate,
               viewCnt,
               status,
               columnName,
               topicIntro,
               topicLogo,
               topicBanner,
               additionalUrl,
               templetId
          from (select column_id      columnId,
                       type           type,
                       item_type      itemType,
                       add_date       addDate,
                       start_date     startDate,
                       end_date       endDate,
                       view_cnt       viewCnt,
                       status         status,
                       templet_id     templetId,
                       column_name    columnName,
                       topic_intro    topicIntro,
                       topic_logo     topicLogo,
                       Topic_banner   topicBanner,
                       additional_url additionalUrl
                  from t_columninfo
                 where type in (4)
                   and status = 1
                 order by add_date desc)     
        )
 where rn > 0
   and rn <= 11