Paging queries for various databases

1. Oracle

Processing by rownum of subqueries

Inner query control maximum, outer query control minimum value

Example:

SELECT * FROM (select A.*,rownum rn from table where RN < Endrow) A where a.rn > StartRow

2. mysql

Direct processing via limit

SELECT * FROM table limit StartRow, Endrow

3. General mode

Using the method of difference sets, first query out the maximum number of rows, and then find the smallest number of rows, the difference set

Example:

SELECT * FROM table where RowNum < Endrow and

ID not in (SELECT ID from table where rownum < StartRow)

Paging queries for various databases