SQL Server Video
92 page views
7552 video views
2024, April 12, Friday

How to: Group Rows in Columns in SQL Server

[#top10] We present in this video how to group values in several records for the same column, separating them by a comma

We will know the techniques:
🔹Delete table (DROP TABLE);
🔹Create table (CREATE TABLE);
🔹Insert records into table (INSERT INTO, VALUES);
🔹Query table (SELECT);
🔹Aggregate values per column (GROUP BY);
🔹Concatenate text from columns (STUFF);
🔹Obtain the distinct records (DISTINCT);
🔹Convert result to XML format (XML PATH).