Merge Rows that have same value in SQL Server

Last Reply 27 days ago By pandeyism

Posted 27 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 27 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