SQL - Pivot Column To Rows with Group By and Concat

Question

I need to traspose a column into a row ( by concatenating it) with group by...

using : sql server 2019

Example

How can i get this?

I tried something but i didn't get close enough to show something here.

Update your post with what you tried, and add a tag for the corresponding dbms you're using. — lemon, May 12 '23 at 15:29

Kazi Mohammad Ali Nur Romel · Accepted Answer · 2023-05-12T16:01:31.943

Need to know your DB name to suggest appropriate answer. It's not pivot rather string aggregation. I will try to cover major RDBMs.

If you are using sql server or postgres you can use string_agg()

Query:

select Car_ID,Car_Name,string_agg(Owner,',') as Owners from Cars
group by Car_ID,Car_Name

Output:

If you are using MySql then you can use group_concat():

Query:

select Car_ID,Car_Name,group_concat(Owner) as Owners from Cars
group by Car_ID,Car_Name

Output:

If you are using Oracle then you can use listagg() for this purpose:

Query:

select Car_ID,Car_Name,listagg(Owner,',') as Owners from Cars
group by Car_ID,Car_Name

Output:

You are most welcome. As simple as it could be. Best wishes. — Kazi Mohammad Ali Nur Romel, May 12 '23 at 16:16

1 Answers1