假设select a,b from c where b=1 order by a有10条结果,我想不通过循环直接取到第5条,能不能做到?语句应该怎么写??
解决方案 »
- oracle11G数据库系统重装,忘记备份啦,只有放在D盘下的datafile文件,如何恢复啊
- 关于SQLStudio里连接oracle数据库怎么做?
- 请问:搞oracle 程序开发 和搞j2ee的。买什么样的笔记本好呀?
- ORACLE_SID、SERVICE_NAME直接的区别与联系
- SQL问题,是否必须用递归
- oracle9的索引和count的问题,急啊!!
- 想学Oracle,要怎么学呢,会有什么困难吗
- Oracle 的存储过程 怎样直接抛出异常提示到界面 (delphi)
- 请教一SQL语句,愚苦想久时,终不得果,望助!
- 存储过程不能执行??
- Oracle创建全文索引错误,提示没有权限?(散分)
- proc 的gui从哪儿装啊
select a,b from (select rownum as no,a,b from c where b=1 order by a) t1 where no=5;
------------
你这样是错误的,select会先得到rownum然后再order by
2 a number(2),
3 b number(1)
4 );Table createdSQL> insert into tab_t values(1,1);1 row insertedSQL> insert into tab_t values(5,1);1 row insertedSQL> insert into tab_t values(9,1);1 row insertedSQL> insert into tab_t values(10,1);1 row insertedSQL> insert into tab_t values(8,1);1 row insertedSQL> insert into tab_t values(20,1);1 row insertedSQL> commit;Commit completeSQL> select a,b from (select rownum as no,a,b from tab_t where b=1 order by a) t1 where no=5; A B
--- --
8 1SQL> select a,b from (select rownum as no,a,b from (select a,b from tab_t where b=1 order by a) t1) t2 where no=5; A B
--- --
10 1经过验证,NinGoo(宁哥 http://NinGoo.itpub.net)是对的,谢谢NinGoo(宁哥 http://NinGoo.itpub.net)