解决方案 »
- 数据库中有单引号的值怎么查找出来
- Oracle 11g OEM 无法登陆
- 关于OEM控制管理工具的问题
- 请教:一条记录里有F1,F2,F3三个属性相同的字段,拆分为3条记录!(在线等待,解决马上送分!)
- 数据库管理高手帮忙!
- ORACLE客户端版本号的查看?
- over() partition by 分组排序问题
- PL/SQL里面包含DBMS_OUTPUT.PUT_LINE 是什么意思?在整条语句当中有什么作用?
- 求助:在删除Oracle81的过程中oci.dll文件删除不了
- 面试题:用sql语句查询十条关于A、B、C、D的记录怎么写?请各位大神帮忙解答,谢谢
- oracle net manager点加号没反应,求助~~~~
- 数据文添加不上
data_id,
group_id,
content_id,
wm_concat(content) --10g或以上才支持
from tablename
group by input_id,
data_id,
group_id,
content_id
SELECT '1' t_id,'a' input_id,'a1' data_id,'aew' content,'2' content_id,'g1' group_id FROM dual
UNION ALL
SELECT '2' t_id,'a' input_id,'a1' data_id,'xc' content,'1' content_id,'g1' group_id FROM dual
UNION ALL
SELECT '3' t_id,'a' input_id,'a2' data_id,'2' content,'1' content_id,'g1' group_id FROM dual
UNION ALL
SELECT '4' t_id,'a' input_id,'a2' data_id,'x' content,'1' content_id,'g2' group_id FROM dual
UNION ALL
SELECT '5' t_id,'a' input_id,'a1' data_id,'3' content,'1' content_id,'g2' group_id FROM dual
UNION ALL
SELECT '6' t_id,'b' input_id,'a1' data_id,'ccc' content,'1' content_id,'g1' group_id FROM dual
UNION ALL
SELECT '7' t_id,'b' input_id,'a1' data_id,'222' content,'2' content_id,'g1' group_id FROM dual
UNION ALL
SELECT '8' t_id,'b' input_id,'a1' data_id,'cc22' content,'3' content_id,'g1' group_id FROM dual
UNION ALL
SELECT '9' t_id,'b' input_id,'a2' data_id,'cxx' content,'1' content_id,'g1' group_id FROM dual
)
SELECT input_id , data_id , wm_concat(content) content ,Min(content_id) , group_id
FROM (
SELECT a.*,ROWNUM rn FROM a)
GROUP BY input_id,data_id,group_id
ORDER BY Min(content_id) ,Min(rn )
结果:
input_id data_id content cid group_id
a a1 aew,xc 1 g1
a a2 2 1 g1
a a2 x 1 g2
a a1 3 1 g2
b a1 ccc,cc22,222 1 g1
b a2 cxx 1 g1
http://www.itpub.net/thread-1332147-1-1.html
呵呵 ,忘了
replace(wm_concat(content),',','')