From: sohelcse@citechco.net
Newsgroups: comp.databases.oracle.misc
Subject: How to make a Crosstab query
Date: Tue, 12 Dec 2000 18:41:54 GMT
Organization: Deja.com
Lines: 26
Message-ID: <915rhg$rac$1@nnrp1.deja.com>
NNTP-Posting-Host: 195.229.2.54
X-Article-Creation-Date: Tue Dec 12 18:41:54 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT)
X-Http-Proxy: 1.0 x64.deja.com:80 (Squid/1.1.22) for client 195.229.2.54
X-MyDeja-Info: XMYDJUIDsohelcse


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/