Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> How to make a Crosstab query

How to make a Crosstab query

From: <sohelcse_at_citechco.net>
Date: Tue, 12 Dec 2000 18:41:54 GMT
Message-ID: <915rhg$rac$1@nnrp1.deja.com>

I have a query output like this :
Client Month Year Sales
------ ------ ---- -----

ABC         JAN    1999     $10,000
ABC         FEB    1999     $5,000
XYZ         JAN    1999     $20,000
XYZ         FEB    1999     $99,000

.
.
.

other months...

How can I make the following type of output in Oracle:

Client    Jan     Feb
------    ---     ---
ABC      10,000   5,000
XYZ      20,000   99,000

.
.

other clients...

Sent via Deja.com
http://www.deja.com/ Received on Tue Dec 12 2000 - 12:41:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US