column values separated by ,
407048Sep 14 2006 — edited Oct 29 2009Suppose say I have table TAB1 with the following data :
COL1 COL2
1 A
1 B
1 C
2 M
2 N
2 O
2 P
2 Q
3 S
3 T
How would I retrieve the data in the following format ?
1 A,B,C
2 M,N,O,P,Q
3 S,T