Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007
    Posts
    33

    Unanswered: How to display rows into column format in udb

    I am trying to display the rows data into columns. Is there any way to do this using SQL in DB2 UDB. I am using db2 udb v8.2.

    Here is what I would like to display from:

    Page# Fieldname Value
    1 FirstName fabc
    1 Lastname labc
    2 Firstname fxyz
    2 Lastnmae lxyz

    To

    Page# Firstname Lastname
    1 fabc labc
    2 fxyz lxyz

    Any pointer?

    Thanks.

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    search
    db2 pivot\unpivot
    on google :-)
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

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