oracle的又一个查询问题,急盼。另,第一个查询问题谢谢飘等。 select * from (select * from test order by session asc) where 1<rownum<5 ; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from (select *,rownum num from (select * from test order by session asc) t) awhere num between 2 and 4 对了,我的是oracle 8i,上面两位的我试了一下,不行。 select * from(select a.* rownum rn from (select * from test order by session asc) a where rownum<=4) where rn>=2; select * from(select a.*,rownum rn from (select * from test order by session) a where rownum<=4) where rn>=2; 谢谢,平平淡淡,可以了,你少了个字母。select * from (select t.*,rownum num from (select * from test order by session asc) t) awhere num between 2 and 4少了t. select * from (select ID, name , session,rownum num from (select * from test order by session asc) ) twhere num between 2 and 4 介绍如何利用rownumhttp://www.chinaunix.net/jh/19/261521.html 存储过程 行列转置 Oraccle 安装后没服务,在线等。。 很急,等着用 ORACLE.EXE (SHAD) pb10运行程序进行调试的时候经常出现未响应 急求一条查询语句-----谢谢啊---第七道题目 触发器的问题 监听器为什么会自动停止????? 请问:Oracle 默认能提供的最大物理Connection数 pritition by range,分区问题 急,请高手帮忙,在线等待! 困惑 不需要安装oracle系统软件吗?
select *,rownum num from (select * from test order by session asc) t) a
where num between 2 and 4
select * from (
select t.*,rownum num from (select * from test order by session asc) t) a
where num between 2 and 4少了t.
select ID, name , session,rownum num
from (select * from test order by session asc) ) t
where num between 2 and 4
http://www.chinaunix.net/jh/19/261521.html