Solution to SQL Server SQL statement query for paginated data_PHP tutorial

For example: it is required to select the record on page 3000 in tbllendlist, with 100 records on each page.
----------
Method 1:
----------
select top 100 * 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 executes faster!
However, this approach is still very troublesome. I strongly look forward to Microsoft inventing a new paging SQL statement! ! ! !

http://www.bkjia.com/PHPjc/631234.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631234.htmlTechArticleFor example: it is required to select the record on page 3000 in tbllendlist, with 100 records on each page. ---------- Method 1: ---------- select top 100 * from tbllendlist where fldserialNo not in ( se...