Oracle中wm_concat的使用

使用的注意事项, groupby后面的值,必须得在select后面中存在. 否则会报错. groupby后面的语句,不要有wm_concat中的值

        SELECT DISTINCT b.kid,
                        A.FAV_ID,
                        A.FAV_TYPE,
                        A.SORT_NUM,
                        A.STAFF_ID,
                        B.TITLE,
                        F.STAFF_NAME,
                        wm_concat(g.lable_name) lable_name
        FROM IM_FAVORITES A
        left join KM_DOCUMENT B
        on A.FAV_ID = B.KID
        left join HRM_STAFF F
        on B.GATHERERS = F.STAFF_ID
        left join KM_DOC_NODE E
        on B.KID = E.KID
        left join km_lable_hrm h
        on b.kid = h.km_id
        left join km_lable g
        on g.lable_id = h.lable_id
        
		WHERE A.FAV_TYPE=1
		
		 	
				AND exists (SELECT C.NODE_ID
                       FROM SSO_GROUP_PERMISSION T, SSO_DATA_PERMISSION C
                      WHERE C.PERMISSION_ID = T.PERMISSION_ID
                        AND GROUP_ID in (${dataPurviewString})
                        AND C.FUNCTIONAL_ID = 1 AND E.NODE_ID=C.NODE_ID)
			
 			AND B.STATUS = 1
			
				AND A.STAFF_ID=#{staff_id}
    		
			
			    
				AND B.TITLE LIKE '%'||#{keyword}||'%'
    		
            
                
                AND h.lable_id in (${lableId})
            
            group by b.kid, A.FAV_ID,
                        A.FAV_TYPE,
                        A.SORT_NUM,
                        A.STAFF_ID,
                        B.TITLE,
                        F.STAFF_NAME
    		 ORDER BY A.SORT_NUM