Grouping a comma separated value on common data [closed]
- by Ankit
I have a table with col1 id int, col2 as varchar (comma separated values) and column 3 for assigning group to them.
Table looks like
col1 col2 group
..............................
1 2,3,4
2 5,6
3 1,2,5
4 7,8
5 11,3
6 22,8
This is…