"Arif" <arif.faruqi_at_gmail.com> wrote in message
news:cae3fa27.0409290822.7e453274_at_posting.google.com...
> Hi Folks,
>
> This is the query I am trying to write. I have a table which can have
> multiple rows for one column say
> Jobid but different values for another column say ticket Id.
>
> Table looks like this.
>
> Job Id Ticket Id
> 1 100
> 1 99
> 2 20
> 2 40
> 2 60
>
> I want to write a query against this table so that I get only one row
> back
> for the job id and the ticket ids for that jobid are concatenated
> together
> like below.
>
> JobId Ticket Id
> 1 100,99
> 2 20,40,60
>
>
> Is this possible through SQL or I have to write some Pl/Sql. can you
> share some code examples
>
> Thanks
Received on Wed Sep 29 2004 - 12:35:56 CDT
