sql语句:
SELECT s_cdbm, wm_concat(s_qxbmj) as s_qxbmj FROM tab_qx
WHERE s_jsbm IN('2203', '4556')
GROUP BY s_cdbm ORDER BY TO_NUMBER(s_cdbm)
查询结果:
3 2,3,4,5,17,2,3,4,5
35 1,2
36 1,2,1,2
想要得到的结果
3 2,3,4,5,17
35 1
36 1,2