急等例子!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
解决方案 »
- 关于ORACLE优化方面问题
- 现在有几百万数据从oracle到出到文件,要用.net实现(请大家提供一个好的解决方法)
- 请教一个SQL查询语句怎么写
- 重建 EM 问题
- willnum>(select avg(willnum),couname,couno from course问题
- 求救:oracle9i 中long raw 数据无法实现表表转移
- 问:表的别名的作用范围 以及 where 子句的执行顺序
- 如何在oracle9i的oracle enterprise manager console里查看各个用户的权限?
- 這個數據庫該如何登陸?
- 数据导出出错,有知道原因的吗,谢谢先了
- HELP!HELP!HELP!关于数据导入、导出的问题
- oracle取出某一段记录错误!
select rownum r,owner,object_name from dba_objects
order by object_id)
where r<11
/select * from (
select rownum r,owner,object_name from dba_objects
order by object_id)
where r>10 and r<=20
/
以次类推分页
select rownum r, from tbname)
where r between (页号-1)*页显示数
and 页号*页显示数;你在jsp中调用过程就可以了
写成这样,首行的user_id还是不能识别。zhangsq:借宝地一用。:)若是单表查询完全同意楼上的。
select rownum r,owner,object_name from dba_objects
order by object_id)
where r<11
/select * from (
select rownum r,owner,object_name from dba_objects
order by object_id)
where r>10 and r<=20(也可使用where r between 10 and 21)
/
select * from (select rownum id,* from 表名) where id>10 and id < 21
select * from table where rownum<40
1 times IO ->Rownum