Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2015
    Posts
    2

    Unanswered: Multiple rows in single column

    I have a table as below:

    COL1 COL2
    1 APPLE
    1 MANGO
    2 ORANGE
    2 BANANA
    1 STRAWBERRY


    I want output as:

    COL1 COL2
    1 APPLE,MANGO,STRAWBERRY
    2 ORANGE,BANANA

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    take a look at listagg other topics that cover this are pivot.
    Dave

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •