17,086
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
doer_ljy 2009-03-11
- 打赏
- 举报
WMSYS.WM_CONCAT如果是9以上的版本。
gxlineji 2009-03-11
- 打赏
- 举报
用分析函数也可以!!
select A,rtrim(B,'/') B,from(
select A,rn,
B||'/'||lead(B) over(partition by A order by A) B
from (
select
B||'/'||lead(B) over(partition by A order by A) B,
row_number() over(partition by A order by A) rn
from t
)
where mod(rn,2) <>0
)
where rn=1
select A,rtrim(B,'/') B,from(
select A,rn,
B||'/'||lead(B) over(partition by A order by A) B
from (
select
B||'/'||lead(B) over(partition by A order by A) B,
row_number() over(partition by A order by A) rn
from t
)
where mod(rn,2) <>0
)
where rn=1
lqb2008 2009-03-11
- 打赏
- 举报
NULL配合GROUP BY可以实现！
sjq521521 2009-03-11
- 打赏
- 举报
[Quote=引用 3 楼 bingkunchen 的回复:]
学习中
[/Quote]
学习中
[/Quote]
bingkunchen 2009-03-10
- 打赏
- 举报
学习中
请输入... 2009-03-10
- 打赏
- 举报
select 字段1,substr(max(sys_connect_by_path(字段2,'/')),2) arr
from (
select 字段1,字段2,row_number() over(order by 字段2) rn
from TABLE1
)
start with rn=1
connect by rn-1=prior rn
group by 字段1
ORCALE 9i
Andy__Huang 2009-03-10
- 打赏
- 举报
ORCALE 10g
SELECT A,REPLACE(WMSYS.WM_CONCAT(B),',','/') B
FROM TB
GRPUP BY A
;
SELECT A,REPLACE(WMSYS.WM_CONCAT(B),',','/') B
FROM TB
GRPUP BY A
;
Finder_Way 2009-03-10
- 打赏
- 举报
顶！学习了
