Database paging Statement (MySQL, Oracle, sqlserver, DB2)

MySQL:

Select * from table name where pid = 0 limit (current page-1) * per page), per page

ORACLE:

Select * from (

Select rownum as RN, source. * from (
SQL statement
) Source where rownum <= (current page * number of entries per page)
) Result where rn> = (current page-1) * How much is displayed on each page)

Sqlserver:

How many * from table name where primary key column not in is displayed on each page of select top?

(Select top (current page-1) * Number of primary key columns displayed on each page from table name order by primary key columns)

Order by primary key column

How to increase the query speed when primary key columns increase automatically

Select top: How many columns are displayed on each page * from table name where primary key column>

(Select max (primary key column) from (select (current page-1) * Number of primary key columns displayed on each page from table name order by primary key column ))

Order by primary key column

 

 

DB2

 

Select * from (
Select row_number () over () as rownum, source .*
From (

SQL statement
) Source
)
Where rownum> = (current page-1) * number of entries per page) and rownum <= (current page * number of entries per page)