ORACLE: SELECT * FROM (SELECT A.*, ROWNUM RN FROM (
select * from table_name t
) A WHERE ROWNUM 0
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (
select * from table_name t
) A WHERE ROWNUM 20*10--- smallRowNum
...
sqlserver:select * from ( select *,row_number() over (order by id) r_n from table_name )where r_n <= 200select * from ( select *,row_number() over (order by id) r_n from tabl...
MYSQL:select * from tbl limit 0,200;select * from tbl limit 200,200;ORACLE:SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM TBL) A WHERE ROWNUM <= 200)...