分页语句

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