--6行被选择耗时0.032秒
select * from (
select t1.*,rownum rn from (
select * from emp order by sal desc
) t1 where rownum<=10
) where rn>=5;--6行被选择耗时0.062秒
select * from (
select t1.*,rownum rn from (
select * from emp order by sal desc
) t1
) where rn between 5 and 10;--6行被选择耗时0.015秒
select * from emp where rowid in (
select rid from (
select rownum rn,rid from(
select rowid rid from emp order by sal desc
)where rownum<=10
)where rn >=5
) order by sal desc;--6行被选择耗时0.031秒
select * from emp where rowid in (
select rid from (
select rownum rn,rid from(
select rowid rid from emp order by sal desc
)
)where rn between 5 and 10
) order by sal desc;--6行被选择耗时0.031秒
select * from (
select t.*,row_number() over(order by sal desc) rn from emp t
)where rn between 5 and 10;
select * from (
select t1.*,rownum rn from (
select * from emp order by sal desc
) t1 where rownum<=10
) where rn>=5;--6行被选择耗时0.062秒
select * from (
select t1.*,rownum rn from (
select * from emp order by sal desc
) t1
) where rn between 5 and 10;--6行被选择耗时0.015秒
select * from emp where rowid in (
select rid from (
select rownum rn,rid from(
select rowid rid from emp order by sal desc
)where rownum<=10
)where rn >=5
) order by sal desc;--6行被选择耗时0.031秒
select * from emp where rowid in (
select rid from (
select rownum rn,rid from(
select rowid rid from emp order by sal desc
)
)where rn between 5 and 10
) order by sal desc;--6行被选择耗时0.031秒
select * from (
select t.*,row_number() over(order by sal desc) rn from emp t
)where rn between 5 and 10;
解决方案 »
- oracle 存储过程 关于游标的一个问题请教
- 创建视图提示权限不足
- oracle 10.0.1 安装后不显示中文界面
- 链接oracle时的问题,请大虾们指点!
- java.sql.SQLException: 数据大小超出此类型的最大值: 2253
- 问一下,oracle job 自动工作,要启动哪些服务
- 大家帮我看看问题处在什么地方~~~文件写入~~~
- 请问怎样列出表空间下所有的表
- 安装Oracle9i Release 2 Services for MTS 9.2.0.7.0 后 oracle 服务器不能启动
- oracle 8.1.7 客户端如何在windows XP 下安装!!!
- proc中查询oracle库提示ORA-01036: illegal name/number
- 求一动态sql语句
select * from (
select t1.*,rownum rn from (
select * from emp order by sal desc
) t1 where rownum<=10
) where rn>=5;--6行被选择耗时0.062秒
select * from (
select t1.*,rownum rn from (
select * from emp order by sal desc
) t1
) where rn between 5 and 10;
如果是大数据量的话 第一种的优势很大