SQL SERVER 2012 T-SQL

[nrajeshkumars]

Hi,

Please provide me the query to get output from the below table.

Table:

1 abc Project1
1 def Project1
2 pqr Project2
2 xyz Project2
1 ghi Project1
3 mno Project3

Out put:

1 Project1 abc,def,ghi
2 Project2 pqr,xyz
3 Project3 mno

Continue reading...