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
SELECT s_cdbm, wm_concat(distinct(s_qxbmj)) as s_qxbmj FROM tab_qx
WHERE s_jsbm IN('2203', '4556')
GROUP BY s_cdbm ORDER BY TO_NUMBER(s_cdbm)
试试这个
使用distinct或者group by
先去重 再使用wm_concat