1.有表t1如下所示:
table T1
ID | NAME |
1 | 霍元甲 |
2 | 霍元甲 |
3 | 黄飞鸿 |
4 | 黄飞鸿 |
5 | 叶问 |
6 | 李小龙 |
7 | 陈真 |
2.oracle
①select NAME,LISTAGG(ID,',') within group (order by ID) AS ID from T1 group by NAME;
②SELECT wm_concat(ID) AS ID FROM T1;
3.postgresql
select array_to_string(array_agg("ID"),',') from "T1"; 结果和2中@一样,不再展示。