| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.tools -> How to make a Crosstab query
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
How can I make the following type of output in Oracle:
Client Jan Feb ------ --- --- ABC 10,000 5,000 XYZ 20,000 99,000
Sent via Deja.com
http://www.deja.com/
Received on Tue Dec 12 2000 - 12:41:54 CST
![]() |
![]() |