1-10:
SELECT 字段1,字段2,... FROM (SELECT b.字段1,b.字段2,...,rownum r FROM 表名 b) where r between 1 and 10
10-20:
SELECT 字段1,字段2,... FROM (SELECT b.字段1,b.字段2,...,rownum r FROM 表名 b) where r between 11 and 20
......
1-10:
SELECT 字段1,字段2,... FROM (SELECT b.字段1,b.字段2,...,rownum r FROM 表名 b) where r between 11 and 20
10-20:
SELECT 字段1,字段2,... FROM (SELECT b.字段1,b.字段2,...,rownum r FROM 表名 b) where r between 11 and 20
......