分页语句

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