首页
开发手册
应用中心
工具
用户中心
SQL Server 2008 Paging and Drive
English
中文简体
English
上一篇
下一篇
###SQL Server 2008 Paging and Drive **Paging section:** BETWEEN start and display content Associated paging statement SELECT * FROM (SELECT a.*,b.names,ROW_NUMBER() OVER (ORDER BY a.id ASC ) AS rowNum FROM fp_admin_user a LEFT JOIN fp_admin_group b ON b.agid=a.gid WHERE a.id=1 OR a.host_id=0 ) b WHERE b.rowNum BETWEEN 1 and 5 Single query paging SELECT * FROM (SELECT *,ROW_NUMBER() OVER (ORDER BY cate_id ASC) AS FPNum FROM fp_category WHERE types='articles_keyword' ) FoundPHP WHERE FoundPHP.FPNum BETWEEN 1 and 5