DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Concat results

  1. 08-06-2001, 03:46 AM #1
    mooks
    mooks is offline Senior Member
    Join Date
    Jan 2000
    Posts
    387

    Post

    Hi,

    If i have the following sql and it will returns more than 1 record.

    select subjects from students
    where name = 'oracle';

    result:
    science
    maths
    english

    in this case, how do i concat it so that it will returns me science||maths||english in a single row? Any help pls? Thanks!
    Reply With Quote Reply With Quote
  2. 08-06-2001, 09:11 AM #2
    aph
    aph is offline Senior Member
    Join Date
    Jul 2001
    Posts
    334
    Use subQuery technique to get your desired result.
    Reply With Quote Reply With Quote
  3. 08-07-2001, 05:53 AM #3
    mooks
    mooks is offline Senior Member
    Join Date
    Jan 2000
    Posts
    387

    Question

    Thanks for the reply. Any examples please?
    Thanks in advance!
    Reply With Quote Reply With Quote
  4. 08-07-2001, 10:42 AM #4
    vbaskar
    vbaskar is offline Member
    Join Date
    Jan 2001
    Posts
    153
    Hi.

    u wanted to transpose the rows right...there are people who did it using MULTIPLe decodes !! just search in the forum for TRANSPOSE..

    Vijay.s
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules

Click Here to Expand Forum to Full Width