c1 c2 c3(position)
FP2 FYLB 2
FP2 FPH 1
FP2_TF YFPH 1
FP2_TF FYLB 2
GFZDMX ZDDH 1
GFZDMX ZDBZ 2
GFZDMX FYLB 3
想问查询出以下结果的SQL怎么写啊..C1 C2
FP2 FYLB,FPH
FP2_TF YFPH,FYLB
GFZDMX ZDDH,ZDBZ,FYLB
FP2 FYLB 2
FP2 FPH 1
FP2_TF YFPH 1
FP2_TF FYLB 2
GFZDMX ZDDH 1
GFZDMX ZDBZ 2
GFZDMX FYLB 3
想问查询出以下结果的SQL怎么写啊..C1 C2
FP2 FYLB,FPH
FP2_TF YFPH,FYLB
GFZDMX ZDDH,ZDBZ,FYLB
解决方案 »
- Oracle视图求优化!恳求大神协助!
- Could not get the storage format of the medium
- 修改sort_area_size参数来提高建索引的效率,好像没效果
- 在JAVABEAN中调用存储过程出现了错误,请达人指点一下。在线等。
- 如何取得table1.field3 = table2.field3的字段,加上table1.field3 is null的字段?
- 灾难性问题,求助,高手请进!!!!!
- 我刚接触oracle,请大家帮忙写个这个触发器。叩首!
- 如何改善查询速度?
- Oracle rollback segment的public和sys有什么区别?
- java调用sqlloader导入csv文件给客户用的求各位高手指教
- 请教一个SQL问题(横表变纵表)
- sqlldr控制文件里里表字段的问题
from t
group by c1;
SELECT c1,
LTRIM(MAX(SYS_CONNECT_BY_PATH(c2,','))
KEEP (DENSE_RANK LAST ORDER BY curr),',') AS c2
FROM (
SELECT m.c1,m.c2,m.c3
ROW_NUMber() over(PARTITION BY m.c1 ORDER BY m.c3)AS curr,
ROW_NUMber() over(PARTITION BY m.c1 ORDER BY m.c3)-1 AS prev
FROM your_table m)
GROUP BY c1
CONNECT BY prev = PRIOR curr
AND c1 = PRIOR c1
START WITH curr = 1;
from t
group by c1;
顶vc555,只是不知道这个vm_concat对资源的占用情况如何啊?