sql - concating columns for rows with same ID
I have a table as follow :
I want to have the following as a result
1 aaa + bbb
that is to concat the columns which their rows have the same ID.