转自:https://blog.51cto.com/seetobest/1397471
group_contact 要连接的字段,把查询的字段连接起来
原数据:
wKioL1NP2zaytnv6AACXXwCf-1I568.jpg
select sex,group_contact(name) from employee group by sex;
wKioL1NP24HSMIHPAABe7ptwT0w199.jpg
select group_contact(name) from employee;
wKiom1NP3Cny69H_AACYR4ugBqc856.jpg