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?