oracle wm_concat() 查询结果去重该怎么做

Question

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

Answer 1

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)
试试这个