Suppose we have a table of two column like:
'A', '12'
'B', '34'
'B', '45'
'B', '67'
'C', '89'
'C', '98'
'D', '43'
Now I want a output shows like:
'A', '12'
'B','34','45', '67'
'C', '89', '98'
'D', '43'
So, what query I have to write for that...??
Loading
Abhimanyu K VatsaPosted Mar 24, 2011, 1:52 AM
As u r wishing to get output, please reply something
Is there any logical relation between
'A' and 12
'B' and 34,45,67
'C' and 89, 98
'D' and 43
Why not something in different form like
'A' and 34,45
'B' and 89
'C' and 98
'D' and 67
I mean there must be some logic that you are wishing to apply to get your output? Please reply.