Introduction to paging query in Oracle, SQL, and DB2

The paging query method for Oracle, SQL, and DB2 is different from that for paging query statements in Oracle and SQL, the following describes the differences between DB2 paging query and paging query in other databases. Oracle paging query syntax: 1: Oracle select * from (select rownum, name from table where rownum <= endIndex) where rownum> startIndex 2: DB2 DB2 paging query SELECT * FROM (Select Field 1, Field 2, Field 3, rownumber () over (column name ASC for order by sorting) AS rn from table name) AS a1 WHERE a1.rn BETWEEN 10 AND 20 or above indicates to extract the select * from (select rownumber () over (order by id asc) records from 10th to 20) as rowid from table where rowid <= endIndex) where rowid> startIndex 3: MySQL: select * from table limit start, pageNum