SELECT A.*
FROM (SELECT ROWNUM num,T.* FROM TABELNAME T WHERE ROWNUM <121) A
WHERE A.num > 99这样就能取出100到120条的纪录
FROM (SELECT ROWNUM num,T.* FROM TABELNAME T WHERE ROWNUM <121) A
WHERE A.num > 99这样就能取出100到120条的纪录
解决方案 »
- 求助 ORA-01460: unimplemented or unreasonable conversion requested
- missing or invalid option
- 求一插入后更新的解发器
- Oracle备份问题
- frm-40207怎麼就難倒了那麼多人!!!
- 求助,ORA-01033
- 请问哪里有oracle学习和帮助文档,最好可以下载看的,参与者有分
- 装了三个多小时还没装上,咋办??
- 如果客户端程序不进行任何操作,能否在数据库中设置一个值将会话断开
- about suspend
- 求助:oracle8恢复问题
- Oracle9i用OMS模式登录时,报“登录身份证不明确”的错误。请高手帮忙!!!
select ename,n
from
(select ename,rownum n
from emp
where rownum <=120)
where n=>100
select * from tempTable where rowNum between 100 and 120
drop table tempTable
FROM (SELECT ROWNUM num,T.* FROM TABELNAME T WHERE ROWNUM <121 order by T.字段名) A
WHERE A.num > 99加个ORDER BY
不就行了!!!!