摘要: 参考: https://www.jb51.net/article/202056.htm https://www.jb51.net/article/251487.htm 阅读全文
posted @ 2022-06-16 10:44 kylinll 阅读(34) 评论(0) 推荐(0)
摘要: SELECT 字段1, [列名] = stuff(( SELECT ',' + [字段2] FROM aa t WHERE t.字段1 = aa.字段1 FOR xml path('')) , 1 , 1 , '') FROM aa GROUP BY 字段1 阅读全文
posted @ 2022-06-16 10:41 kylinll 阅读(184) 评论(0) 推荐(0)