这样:
select * from (select rownum,a.* from table1 a) b
where b.rownum>50
and b.rownum<=60
select * from (select rownum,a.* from table1 a) b
where b.rownum>50
and b.rownum<=60
解决方案 »
- 如何将Oracle中写入的数据实时的写到另一个Oracle库中?
- Oracle 10g安装过后怎样调整内存分配大小
- 高手帮忙下,怎么分段查询
- 有人知道哪家培训orcale10g面向企业级培训??
- startup force报错
- 我装的是oracle9i,是否要装oracle developer9i?如果是的,希望哪位达人可以提供下地址下载,谢谢
- 50分~~~~~~寻求查询答案~~~~~~~!!!
- "表或视图不存在"的问题。
- 数据类型问题
- 在ORACLE中,表被锁死(表处于挂起状态,不能再删除,添加数据)怎么办
- 请问Oracle的数据库备份命令是什么?
- 请问WINDOW98环境下可以运行ORACLE吗?在哪里下载?多谢!
minus
select * from table1 where rownum <=50
you should try to search the answer by yourself . there are plenty of same questions which are discussed before
select * from(select * from(select * from (select * from 表名 order by ID desc)
where rownum<50) order by ID) where rownum<61;
where b.rownum>50
where b.aa > 50