CREATE TABLE aa (c1 VARCHAR2(5),c2 VARCHAR2(5));
INSERT INTO aa VALUES('v2','a');
INSERT INTO aa VALUES('v2','b');
INSERT INTO aa VALUES('v2','c');
INSERT INTO aa VALUES('v2','d');
INSERT INTO aa VALUES('v2','e');
COMMIT;
可否按每两笔分组, 效果如下:
"rid" c1 c2
1 v2 a
1 v2 b
2 v2 c
2 v2 d
3 v2 e
INSERT INTO aa VALUES('v2','a');
INSERT INTO aa VALUES('v2','b');
INSERT INTO aa VALUES('v2','c');
INSERT INTO aa VALUES('v2','d');
INSERT INTO aa VALUES('v2','e');
COMMIT;
可否按每两笔分组, 效果如下:
"rid" c1 c2
1 v2 a
1 v2 b
2 v2 c
2 v2 d
3 v2 e
解决方案 »
- oracle百万数据单表查询最短时间
- 走过路过千万不要错过啊,刚刚出炉的问题,求指导!!!"操作超时"问题
- oracle 9i Enterprise manager console打不开了,火烧眉毛,小妹我急啊
- oracle 和C#
- 视图问题:1,对于多表联接的视图,DML操作时,是怎么达到增删改的目的的?2,什么情况下会对视图DML,一般不是直接增删改表么?
- 我发现目前号称最高效的oracle分页SQL语句的一个重大漏洞,关心的网友请进来讨论
- 有关LIKE的用法
- 菜鸟问题~
- 在oracle8i中如何建表?请顺便告诉我步骤。急!!!!谢谢
- WINDOWS7旗舰版32位系统安装oracle11g问题
- Oracle中,date 型数据的比较问题
- SQL语句优化!!!!!!!!!!!!!!
decode(MOD(a.rid+1,2),1,a.rid/2,(a.rid+1)/2) as rid,
a.c1,
a.c2
from
(select rowid as rid,* from aa) a
select
decode(MOD(a.rid+1,2),1,a.rid/2,(a.rid+1)/2) as rid,
a.c1,
a.c2
from
(select ROWNUM as rid,c1,c2 from aa) a
decode(MOD(a.rid+1,5),1,a.rid/5,2,(a.rid-1)/5,3,(a.rid-2)/5,4,(a.rid-3)/5,(a.rid+1)/5) as rid,
a.c1,
a.c2
from
(select ROWNUM as rid,c1,c2 from aa) a