语源科技BlogJava-cflianna

语源科技BlogJava-cfliannahttp://www.blogjava.net/cflianna/zh-cnSun, 12 Apr 2026 06:03:04 GMTSun, 12 Apr 2026 06:03:04 GMT60如何用SQL语句把查询出来的多条记录组成一个字符串输出?http://www.blogjava.net/cflianna/archive/2012/04/24/376500.htmlcflovethisworldcflovethisworldTue, 24 Apr 2012 10:32:00 GMThttp://www.blogjava.net/cflianna/archive/2012/04/24/376500.htmlhttp://www.blogjava.net/cflianna/comments/376500.htmlhttp://www.blogjava.net/cflianna/archive/2012/04/24/376500.html#Feedback1http://www.blogjava.net/cflianna/comments/commentRss/376500.htmlhttp://www.blogjava.net/cflianna/services/trackbacks/376500.html

区域省份城市
华北河北石家庄
华北河北秦皇岛
华北山西太原
华北内蒙古包头
东北辽宁大连
东北吉林吉林
东北辽宁沈阳
东北辽宁鞍山
华南湖南张家界
华南广东广州

变为

华北河北，山西，内蒙古
东北辽宁，吉林
华南湖南，广东

select area,wmsys.wm_concat(province) from (select distinct area,province from table) group by area

select 区域 ,
substr(max(sys_connect_by_path(省份,',')),2) 省份,
from ( select
区域,省份, row_number() over(order by 省份) rn
from 表名 )
)
start with rn=1
connect by rn-1=prior rn
group by 区域

cflovethisworld 2012-04-24 18:32 发表评论

]]>第一次来到这里，打算留下我程序路上进步和改变的点点滴滴http://www.blogjava.net/cflianna/archive/2012/04/11/373794.htmlcflovethisworldcflovethisworldWed, 11 Apr 2012 05:22:00 GMThttp://www.blogjava.net/cflianna/archive/2012/04/11/373794.htmlhttp://www.blogjava.net/cflianna/comments/373794.htmlhttp://www.blogjava.net/cflianna/archive/2012/04/11/373794.html#Feedback2http://www.blogjava.net/cflianna/comments/commentRss/373794.htmlhttp://www.blogjava.net/cflianna/services/trackbacks/373794.html

cflovethisworld 2012-04-11 13:22 发表评论

]]>