if my database table is like:
x
name col_2
Manish 352-103
Manish 342-123
ganesh 362-111
ganesh 789-232
abcd 456-231
abcd 047-234
now i want it as:
name col-2
Manish 352-103, 342-123
ganesh 362-111, 789-232
abcd 456-231, 047-234
(I need distinct values of name and col-2 values must appended for the each distinct value of name) Both column values are of type text
Advertisement
Answer
This solved the requirement in MySQL
select name, group_concat(col-2) from dbo.sample group by name