Saturday, April 13, 2019

mysql - Does anyone know how to Stuff in groups?

I am trying to use the stuff function in MS SQL to stuff certain info. Here is the example:



Number          Value 
1 1
2 1
3 1
1 2

2 2
3 2
1 3
2 3


I would like to stuff the column so that only one record will display as following:



Value             Number
1 1,2,3

2 1,2,3
3 1,2


Please note that there are a like n-Numbers and n-Values.

No comments:

Post a Comment

plot explanation - Why did Peaches' mom hang on the tree? - Movies & TV

In the middle of the movie Ice Age: Continental Drift Peaches' mom asked Peaches to go to sleep. Then, she hung on the tree. This parti...