A solution to query paging data for SQL Server SQL statements

server| Page | resolution | data | statement

For example: request to select the No. 3000 page of tbllendlist records, each page 100 records.

----------
Method 1:
----------
Select Top * from Tbllendlist
where Fldserialno not in
(
Select Top 300100 fldserialno from Tbllendlist
ORDER BY Fldserialno
)
ORDER BY Fldserialno

----------
Method 2:
----------
SELECT Top 100 *
From Tbllendlist
WHERE (Fldserialno >
(SELECT MAX (Fldserialno)
From (SELECT top 300100 Fldserialno
From Tbllendlist
Order by Fldserialno) as T)
ORDER BY Fldserialno

Method 1 Execution speed is relatively fast!

However, this approach is still very troublesome, and strongly expect Microsoft to invent new!!!! SQL statements to