sqlserver 分页

概述1.rowNum select * from  (select *,ROW_NUMBER() over (order by id ) as rowNum from BD_city) as t where t.rowNum between 3*(2-1)+1  and 3*2 2.top  SELECT * FROM ( SELECT TOP 3 * FROM (SELECT  top 40 *  

1.rowNum

select * from 

(select *,ROW_NUMBER() over (order by ID ) as rowNum from BD_city) as t

where t.rowNum between 3*(2-1)+1  and 3*2

2.top

 SELECT * FROM ( SELECT top 3 * FROM (SELECT  top 40 *  FROM   (select t1.*,t2.satellite_ID  from table1 t1 left join table2 t2)   as mm ORDER BY ID asc) AS TEMPtable1   ORDER   BY ID desc)AS TEMPtable2 ORDER BY ID ASC

总结

以上是内存溢出为你收集整理的sqlserver 分页全部内容，希望文章能够帮你解决sqlserver 分页所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。