首页
开发手册
应用中心
工具
用户中心
SQL Server 2008 分页与驱动
中文简体
中文简体
English
上一篇
下一篇
###SQL Server 2008 分页与驱动 **分页部分:** BETWEEN 开始 and 显示内容 关联分页语句 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 单查询分页 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