SQL Query to get aggregated result in comma separators along with group by column in SQL Server

by

You want to use FOR XML PATH construct:

select 
    ID, 
    stuff((select ', ' + Value 
           from YourTable t2 where t1.ID = t2.ID 
           for xml path('')),
          1,2,'') [Values]
from YourTable t1
group by ID

The STUFF function is to get rid of the leading ', '.

You can also see another examples here:

More Related Contents:

  1. SQL comma-separated row with Group By clause
  2. How do I UPDATE from a SELECT in SQL Server?
  3. How to use GROUP BY to concatenate strings in SQL Server?
  4. SQL update from one Table to another based on a ID match
  5. Optimal way to concatenate/aggregate strings
  6. What is the difference between using a cross join and putting a comma between the two tables?
  7. The SQL OVER() clause – when and why is it useful?
  8. Fastest way to determine if record exists
  9. Group DateTime into 5,15,30 and 60 minute intervals
  10. Best way to do nested case statement logic in SQL Server
  11. How to select only the first rows for each unique value of a column?
  12. Grouped string aggregation / LISTAGG for SQL Server
  13. how does SELECT TOP works when no order by is specified?
  14. Combine Two Tables in Select (SQL Server 2008)
  15. SQL, How to Concatenate results?
  16. Case statement for multiple columns
  17. SQL where clause odd behavior [closed]
  18. SQL Server Exec issue [closed]
  19. Count(*) vs Count(1) – SQL Server
  20. Selecting data from two different servers in SQL Server
  21. PostgreSQL: running count of rows for a query ‘by minute’
  22. Is a view faster than a simple query?
  23. SQL SELECT WHERE field contains words
  24. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  25. How to include “zero” / “0” results in COUNT aggregate?
  26. SQL SELECT speed int vs varchar
  27. What’s the best way to capitalise the first letter of each word in a string in SQL Server
  28. Does Sql JOIN order affect performance?
  29. Best equivalent for IsInteger in SQL Server
  30. Using tuples in SQL “IN” clause

Leave a Comment