1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Sql string separation

Discussion in 'Other Databases' started by anandarju, Mar 9, 2016.

  1. anandarju

    anandarju Starter

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    United Kingdom
    I am new to SQL and SQL development; I want the output I mentioned below using SQL from the Table A:

    I use Nettezza DB for SQL development so please provide query according to that. Thanks in Advance.

    Table A:

    |Name | Account | Actions
    | ABC | 23423 | swim,run,play
    |NDHD | 540244 | play,swim,fly

    Output Required:

    |Name | Account | Actions
    |ABC | 23423 |swim
    |ABC | 23423 |run
    |ABC | 23423 |play
    |NDHD | 540244 |play
    |NDHD | 540244 |swim
    |NDHD | 540244 |fly
     
    Last edited: Mar 10, 2016
  2. anandarju

    anandarju Starter

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    United Kingdom
    Dear Sergey Krasnoslobodtsev,
    I forgot to mention in the my main thread, I use 'Aginity Workbench' as development tool for my work. Hence I think probably, this code will not work in my system. It would be helpful if you can give any code that are related with Netezza.
     
  3. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.

    Yes, Netezza doesn't support hierarchical queries.

    What version of your Netezza DB ?

    P.S. I believe ,that the messages of Netezza DB better has been moved to Other Database.
     
    Last edited: Mar 11, 2016