表:table
id | name |
---|---|
1 | a |
1 | b |
查询分组组合语句
select id,wmsys.wm_concat(name) as name from table group by id
结果
id | name |
---|---|
1 | a,b |
表:table
id | name |
---|---|
1 | a |
1 | b |
查询分组组合语句
select id,wmsys.wm_concat(name) as name from table group by id
结果
id | name |
---|---|
1 | a,b |
转载于:https://my.oschina.net/papio/blog/997743