本文共 1484 字，大约阅读时间需要 4 分钟。

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

        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	

转载地址：https://javaweixin6.blog.csdn.net/article/details/84797720 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！