分页语句

来源：网络责任编辑：admin 发表时间:2013-07-01 23:23　点击:次

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