<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    隨筆-16  評論-84  文章-1  trackbacks-0

    Here i take jobs table of pubs databse for example,details as follow: 

    select top eachpage *  from  jobs where job_id not in ( select top (eachpage*(currentpage-1))  job_id from jobs order by job_id desc)) order by job_id desc;

    explain:
    1. eachpage : the number of each page show the recorder
    2.currentpage: current page

    notice:
    the red line in the sentence,you should take care of it, because Microsoft SQLServer  TOP Function can't support the expression .it can only support a number.
    so before you prepare to buildup the sql sentence ,you should alread calculate the result of the expression about (eachpage*(currentpage-1))  .

    Example:
    set  eachpage=3
          currentpage=5
     so  (eachpage*(currentpage-1)) =12
    select top 3 * from jobs where (job_id not in (select top 12 job_id from jobs order by job_id desc)) order by job_id desc


    posted on 2008-12-03 16:00 absolute 閱讀(544) 評論(0)  編輯  收藏 所屬分類: DataBase
    主站蜘蛛池模板: 中文在线免费不卡视频| 亚洲a∨国产av综合av下载| 国产精品青草视频免费播放| 国产精品国产免费无码专区不卡| 亚洲国产成人久久| 欧美最猛性xxxxx免费| 亚洲国产视频一区| 精品香蕉在线观看免费| 亚洲国产视频网站| 久久精品免费一区二区喷潮| 亚洲七久久之综合七久久| 拨牐拨牐x8免费| 亚洲av无码专区青青草原| 国产又大又粗又硬又长免费| 精品在线免费视频| 免费女人18毛片a级毛片视频| 黄网站色成年片大免费高清| 亚洲精品一级无码鲁丝片| a毛片免费在线观看| 亚洲AV成人精品网站在线播放| 13一14周岁毛片免费| 亚洲一区二区三区无码国产| 成人免费看吃奶视频网站| 暖暖免费中文在线日本| 亚洲AV日韩AV高潮无码专区| 妻子5免费完整高清电视| 亚洲AV成人无码久久WWW| 伊人久久综在合线亚洲91| 香港a毛片免费观看| 亚洲中文字幕无码av永久| 亚洲 国产 图片| 免费A级毛片av无码| 在线aⅴ亚洲中文字幕| 午夜亚洲福利在线老司机| 在线人成免费视频69国产| 亚洲大香人伊一本线| 国产乱人免费视频| 国产好大好硬好爽免费不卡| 亚洲xxxxxx| a级亚洲片精品久久久久久久 | 亚洲国产成人久久综合碰碰动漫3d |