var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Concatenating a Single Field, Multiple Records
I am new to SQL and are having a tough time with this particular query. I need a way to group multiple records into one and concatenate text data from a single field.
If this is the data within the table:
ID SEQ SOME_FIELD
1 1 Mark
1 2 Paul
1 3 John
2 1 Mark
2 2 Paul
3 1 Chris
3 2 Jen
3 3 John
3 4 Doug
3 5 Steve
This is what I want to return in the query:
1 Mark, Paul, John
2 Mark, Paul
3 Chris, Jen, John, Doug, Steve
I really need it to be a concatenated result with some delimiter.
I am using Oracle 9i.