原始数据:
ID NAME
102010004 xion
102010004 lb_s
102010002 ganh
102010004 luor
102010001 wang
102010007 wuhs
102010001 yanl
102010001 chen
102010001 tanb
102010002 chen
102010001 liro
102010007 yaox
102010003 chen
102010003 renx
102010002 wang
102010008 wang
102010002 lixy
分组拼接后的数据:
ID NAMES
102010001 wang,liro,tanb,chen,yanl
102010002 ganh,lixy,wang,chen
102010003 chen,renx
102010004 xion,luor,lb_s
102010007 wuhs,yaox
102010008 wang
sql语句:
select ID, wm_concat(NAME) NAMES from 表名 group by ID