Pagination using over Window Function

In SQL Server, there are also many paging methods using SQL. Today we want to summarize the over window function introduced in SQL Server 2005, and then the window function is used for paging.

The sample code is as follows:

-- Set the database context use tsqlfundamentals2008; go -- use row_number paging to find the 1-10 data records select T. custid, T. companyName, T. address, T. city from (select row_number () over (order by custid) as rownum, custid, companyName, address, city from sales. customers) as twhere T. rownum between 1 and 10

Query results:

Output 1st to 10th records.