Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    20

    Red face Unanswered: easy query for you...

    hi can you help me? i have a table like this:
    agent client year import
    ------ ---------- ---- ---------------------
    2 DF 2004 3,00000000000000E+001
    2 DF 2004 7,02166900000000E+004
    1 DF 2003 6,47549000000000E+003
    2 DIEFFE 2004 7,14400000000000E+001
    1 ISC 2004 1,50000000000000E+001
    2 ISC 2003 4,00000000000000E+001


    but i needed a table like:

    agent client import2003 import2004

    have you any idea? thanks

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Thumbs down

    This is the never ending question.


    Look up 'pivot table' in http://asktom.oracle.com

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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