Three common forms of SQL paging

2. --top not in mode
4. Select Top Bar number * from tablename
6. where Id not in (select Top Bar Number * page Id from tablename)
14. --row_number () over () mode
16. SELECT * from (
18. 　　　　SELECT *, Row_number () over (Order by Id) as RowNumber from tablename
20. ) as b
22. 　　Where RowNumber between current page -1* number of pages and pages * Number of bars
30. --offset FETCH Next Way
32. --SQL2012 more than version support
34. SELECT * FROM tablename
36. ORDER by Id offset page row fetch Next number row only

Analysis: When the amount of data is large

Top not in mode: query data faster than before

Row_number () over () mode: query data faster than the previous one

Offset fetch Next method: Stable speed, better than the first 2, but the SQL version limit of 2012 and above to use

Three common forms of SQL paging