摘要:
SqlServer 2017+版本可以使用如下语句 SELECT GroupColumn, STRING_AGG(TargetColumn, ',') WITHIN GROUP (ORDER BY TargetColumn) AS MergedStrings FROM YourTable GROUP 阅读全文
posted @ 2024-07-25 15:04
飘扬De黑夜
阅读(93)
评论(0)
推荐(0)
|
摘要:
SqlServer 2017+版本可以使用如下语句 SELECT GroupColumn, STRING_AGG(TargetColumn, ',') WITHIN GROUP (ORDER BY TargetColumn) AS MergedStrings FROM YourTable GROUP 阅读全文
posted @ 2024-07-25 15:04
飘扬De黑夜
阅读(93)
评论(0)
推荐(0)
|