SQLSERVER实现group_concat,wm_concat的方法

SELECT   INDTYPE,
                 IND =
                   STUFF((SELECT ',' + TMP.IND + '(0.23)'
                          FROM   COD_BASE_INDEXS TMP
                          WHERE  1 = 1
                          FOR XML PATH('')),
                         1,
                         1,
                         '')
        FROM     COD_BASE_INDEXS
        GROUP BY INDTYPE

 

posted on 2022-03-07 10:16  骑着母猪去打猎  阅读(987)  评论(0编辑  收藏  举报