Database paging query and database Paging

Database paging query and database Paging

1) mysql

Select * from demowhere1 = 1 LIMIT 2 and 3

Limit is used for paging. The first parameter is the row number, and the second parameter is the number of rows.

2) oracle

First

Select id, FIELD_NAME ,... FROM TABLE_NAME where id in (select id from (select rownum as numrow, id from TABLE_NAME WHERE Condition 1 order by condition 2) where numrow> 80 and numrow <100) order by Condition 3;

Second

SELECT * FROM (SELECT a. *, rownum rn FROM (SELECT * FROM table_name) a WHERE rownum <= 40) WHERE rn> = 21

If scrollable result is supported, use the absolute method of ResultSet to directly move to the query start point. If not, use the loop statement and move rs. next a little bit.

Zookeeper