SQL to Concat colmn values of Diff records [message #19654] |
Tue, 02 April 2002 22:40 |
Suresh
Messages: 189 Registered: December 1998
|
Senior Member |
|
|
I have data like this
city------street
hyd------st1
hyd------st2
hyd------st3
Bglore---st1
Bglore---st2
Bglore---st3
i would like to retrive the data as following..
hyd------ st1,st2,st3
Bglore---- st1,st2,st3
How can we do this.
regards,
Suresh Babu
|
|
|
|
Re: SQL to Concat colmn values of Diff records [message #19661 is a reply to message #19659] |
Wed, 03 April 2002 01:37 |
Suresh
Messages: 189 Registered: December 1998
|
Senior Member |
|
|
I have requirement as follows
Use Join on ResumeMaster, SkillMaster ,ResumeSkill
i get the follwing..
ResumeId-------skillName
1-------C
1-------C++
2-------Java
3-------C
3-------C++
3-------VC++
Since i have to show my records in the UI as follows
ResumeId--- Skill1,Skill2,Skill3..
i am doing this in the programme rather i would like to do this on the oracle side itself so that i can get less no of records which would lead to a better performance..
and mind you i donot need the skillId.
thank u
|
|
|
|