Saturday 13 April 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

php - file_get_contents shows unexpected output while reading a file

I want to output an inline jpg image as a base64 encoded string, however when I do this : $contents = file_get_contents($filename); print &q...