Paging queries for each database

2. SQL Server Paging
4. The first method of paging
6. Parameters to be required:
8. PageSize How many data are displayed per page
10. PageNumber pages coming from the client
12. Total number of records in the Totalrecouds table select COUNT (*) from table name
14. TotalPages Total Pages
16. totalpages=totalrecouds%pagesize==0?totalrecouds/pagesize:totalrecouds/pagesize+1
18. Pages to calculate the previous pages bar data
20. pages= pagesize* (pagenumber-1)
22. SQL statements:
24. Select Top PageSize * FROM table name where ID not in (select top pages ID from table name ORDER by ID) Order by ID
26. The second method of paging
28. PageSize How many data are displayed per page
30. PageNumber pages coming from the client
32. pages=pagesize* (pagenumber-1) +1
34. Select Top PageSize * from table name where id>= (select Max (ID) from (select top pages ID from table name ORDER BY ID ASC) T)
38. MySQL Paging
40. Parameters to be required:
42. PageSize How many data are displayed per page
44. PageNumber pages coming from the client
46. Total number of records in the Totalrecouds table select COUNT (*) from table name
48. TotalPages Total Pages
50. totalpages=totalrecouds%pagesize==0?totalrecouds/pagesize:totalrecouds/pagesize+1
52. Pages Start location
54. pages= pagesize* (pagenumber-1)
56. SQL statements:
58. SELECT * from table name limit pages, pageSize;
60. MySQL paging relies on the keyword limit it requires two parameters: start position and pagesize
62. Start Position = page Size * (pages-1)
64. Starting position =pagesize* (PageNumber-1)
68. Oracle Paging
70. PageSize How many data are displayed per page
72. PageNumber pages coming from the client
74. Total number of records in the Totalrecouds table select COUNT (*) from table name
76. TotalPages Total Pages
78. totalpages=totalrecouds%pagesize==0?totalrecouds/pagesize:totalrecouds/pagesize+1
80. StartPage Start position
82. Startpage= pagesize* (pagenumber-1) +1
84. Endpage=startpage+pagesize
86. SQL statements
88. Select A.* from
90. (
92. Select RowNum num, t.* from table name t where column = some value order by ID ASC
94. ) A
96. where A.num>=startpage and A.num<endpage
100. DB2 Sub-page
102. int startpage=1 //Start Page
104. int endpage; //Termination page
106. int pagesize=5; //Page size
108. int pagenumber=1 //Request page
112. Startpage= (pagenumber-1) *pagesize+1
114. Endpage= (startpage+pagesize);
120. SQL statements
122. SELECT * FROM (select field 1, Field 2, field 3, field 4, field 5,rownumber () over (Order by sort field ASC) as rowID from table name) as a where A.rowid >= startpage and A.rowid <endpage
126. Access Paging
128. PageSize How many data are displayed per page
130. PageNumber pages coming from the client
132. pages=pagesize* (pagenumber-1) +1
134. SQL statements
136. Select Top PageSize * from table name where id>= (select Max (ID) from (select top pages ID from table name ORDER BY ID ASC) T)

Reprinted from: https://www.cnblogs.com/luanyichao/p/7825086.html

Paging queries for each database