有blob类型的话 select * from(select rownum rn,t.* from TABLE__NAME t) where rn>10 and rn<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 ......
更正: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 ......
SELECT * FROM TABLE__NAME WHERE ROWNUM<10;
10-20条
SELECT * FROM TABLE__NAME WHERE ROWNUM<20
MINUS
SELECT * FROM TABLE__NAME WHERE ROWNUM<10;
select * from(select rownum rn,t.* from TABLE__NAME t) where rn>10 and rn<20;
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
......
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
......