select t1.name,wm_concat(t1.sl||t1.mc)from my_table t1 group by t1.name;
http://bbs.csdn.net/topics/350155782最大小于4000,否则只能用临时表了。