oracle实现如下效果表 aid name1 a2 b3 c4 d
需要结果集为
id name 1 b2 c3 d4 a有好的写法不
需要结果集为
id name 1 b2 c3 d4 a有好的写法不
解决方案 »
- select 语句求教
- 这条sql语句怎么优化?求教高手
- 大家说说这是怎么回事
- 问一下PL\SQL中EXCEPTION的问题
- oracle的表中 date类型插入和查询的数值不一致啊
- 如何在查询结果中,将两个字段的信息,在一个字段中显示?解决马上结帖?
- 导入数据库的问题!请高手指教!
- Error in run runInstaller.sh............
- 哪位高手能给我篇在TRU64上安装oracle920的安装文档?
- [unicode]关于oracle817数据库中简繁体共存的问题!
- oracle出现了很奇怪的问题,不信你来看看,求解………………大神何在???
- 重复记录保留一条的初级问题
(
ID NUMBER(4),
F1 VARCHAR2(20)
);INSERT INTO T190 VALUES(1, 'a');
INSERT INTO T190 VALUES(2, 'b');
INSERT INTO T190 VALUES(3, 'c');
INSERT INTO T190 VALUES(4, 'd');
测试结果:
lag() over 和lead() over()
with t as(
select 1 id, 'a' name from dual
union all
select 2,'b' from dual
union all
select 3,'c' from dual
union all
select 4,'d' from dual
)select id,name from t order by mod(id,4)
ID NAME
---------- ----
4 d
1 a
2 b
3 c
with t as(
select 1 id, 'a' name from dual
union all
select 2,'b' from dual
union all
select 3,'c' from dual
union all
select 4,'d' from dual
)select id,name from t order by mod(id+2,4)
ID NAME
---------- ----
2 b
3 c
4 d
1 a
with t as(
select 1 id, 'a' name from dual
union all
select 2,'b' from dual
union all
select 3,'c' from dual
union all
select 4,'d' from dual
)select mod(id+2,4)+1 id,name from t order by id ID NAME
---------- ----
1 b
2 c
3 d
4 a