Merge Rows that have same value in SQL Server

Last Reply 25 days ago By pandeyism

Posted 25 days ago

I have a table in SQL that have a CourseId field. an I want to merge the rows that have the same value.

Regarding the above picture, I want to show that rows that I highlighted them in one row.

the exact output that I want is :

how can I do this in SQL?

Posted 25 days ago

Hey dorsa,

It's not possible.

You need to do it from code behind.

Refer below article for merging.

Merge GridView Cells or Columns in a Row in ASP.Net using C# VB.Net