I have a table in SQL that have a CourseId field. an I want to merge the rows that have the same value.
![http://uupload.ir/files/zagt_225.png](https://i.imgur.com/tjgTB5o.png)
Regarding the above picture, I want to show that rows that I highlighted them in one row.
the exact output that I want is :
![http://uupload.ir/files/2mk3_226.png](https://i.imgur.com/u4Kf395.png)
how can I do this in SQL?