SQL Server / MySQL | Combine data from multiple rows into a single row

| By Webner

We have data as below:

We need output like this:

For SQL server
STUFF function is the key here:

SELECT distinct '  ' + cast(Name as varchar(500))  from table1 t2  where t1.Id = t2.Id  FOR XML PATH(''), TYPE ).value('.', 'NVARCHAR(MAX)')  ,1,2,’ ‘
New_Name from table1 t1 group by Id,Name

MySql: In case of the MySQLGROUP_CONCAT function is used. Also, we can give the desired delimiter using SEPARATOR keyword:

SELECT id, GROUP_CONCAT(name SEPARATOR '  ') as New_Name FROM test GROUP BY id;

Leave a Reply

Your email address will not be published. Required fields are marked *