select * from you_table where rownum<100 minus select * from you_table where rownum<10
//取第11到20条数据 select * from (select rownum id,* from tbname where rownum<21) a where a.id>10;
楼上的兄弟: select * from (select *,rownum id from all_tables where rownum<21) a where a.id>10; *ERROR 位于第 1 行: ORA-00923: 未找到预期 FROM 关键字 ?????????????thanks
select * from (select rownum id,table_name,pct_free from all_tables where rownum<21) a where a.id>0;
在SQLPLUS可以,SET PAUSE ON实现分页
并不是sql plus,受环境限制,只能用纯sql实现,不能依靠delphi与pb的组件提供的相关功能啊!
select * from (select rownum id,* from tbname where rownum<21) a
where a.id>10;
select * from (select *,rownum id from all_tables where rownum<21) a where a.id>10; *ERROR 位于第 1 行:
ORA-00923: 未找到预期 FROM 关键字 ?????????????thanks