sql导出数据集的数据

column-1 column-2 动物狗，狮子，老虎，山羊 这是否可以派生I have table column-1 column-2 Animal dog Animal lion Animal tiger Animal goat I want the result as column-1 column-2Animal dog,lion,tiger,goat Is This Possible to derive推荐答案 如果是SQL Server，您可以使用 XML PATH 来完成此操作。 你必须查询类似的东西 - If it is SQL Server, you can do this using XML PATH.You have to query something like-SELECT Column1 ,STUFF((SELECT ', ' + Column2 [text()] FROM YourTable WHERE Column1 = t.Column1 FOR XML PATH(''), TYPE) .value('.','NVARCHAR(MAX)'),1,2,' ') Column2FROM YourTable tGROUP BY Column1 示例： EXAMPLE:DECLARE @MyTable TABLE(Column1 VARCHAR(20), Column2 VARCHAR(20))INSERT INTO @MyTable VALUES ('Animal', 'dog'),('Animal', 'lion'),('Animal', 'tiger'),('Animal', 'goat')SELECT Column1 ,STUFF((SELECT ', ' + Column2 [text()] FROM @MyTable WHERE Column1 = t.Column1 FOR XML PATH(''), TYPE) .value('.','NVARCHAR(MAX)'),1,2,' ') Column2FROM @MyTable tGROUP BY Column1 希望，它有助于：）Hope, it helps :) 这篇关于sql导出数据集的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！