摘要： Reference from http://www.codeproject.com/Articles/18148/SQL-Server-2005-Paging-ResultsWith Cust AS ( SELECT CustomerID, CompanyName, ROW_NUMBER() OVER (order by CompanyName) as RowNumber FROM Customers )select *from CustWhere RowNumber Between 20 and 30 阅读全文