请问下SQL如何按分组合并汇总各组内的值？

请问下各位怎么用SQL实现图中这种操作，就是按分组合并各值

网上搜索分组合并字符串，会有很多参考~这里提供一种mysql的参考吧

1. SELECT bin,concat (GROUP_CONCAT(id),"\") AS ids FROM tb_name GROUP BY bin

复制代码

01.SELECT bin,concat (GROUP_CONCAT(id),"\") AS ids FROM tb_name GROUP BY bin