分页语句

最新推荐文章于 2024-07-17 08:42:49 发布

原创最新推荐文章于 2024-07-17 08:42:49 发布 · 145 阅读

0 ·

CC 4.0 BY-SA版权

Oracle 专栏收录该内容

8 篇文章

订阅专栏

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


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