USE AdventureWorks2012; GO WITH OrderedOrders AS ( SELECT SalesOrderID, OrderDate, ROW_NUMBER() OVER (ORDER BY OrderDate) AS RowNumber FROM Sales.SalesOrderHeader ) SELECT SalesOrderID, OrderDate, RowNumber FROM OrderedOrders WHERE RowNumber BETWEEN 50 AND 60;
可以参考一下
非常感谢!
数据库分页:row_number分页,博客园有很多,你搜索下就知道了。
查查ajax无刷新分页, 很多例子与控件, 简单又方便,而且ajax也是技术走向的路标。