Home » SQL & PL/SQL » SQL & PL/SQL » cross tabulation question
cross tabulation question [message #37308] Wed, 30 January 2002 08:09 Go to next message
Lee
Messages: 56
Registered: May 1999
Member
I need to do a cross tabulation without using DECODE. Is there a way to do this? Basically I have table :

Level Code Number St
1 A 25 AZ
1 B 20 AZ
2 A 15 HI
2 B 10 HI

Desired Output:

Level A B St
1 25 20 AZ
2 15 10 HI

I can't use Decode because there are many different Codes. Any help would be much appreciated. Thanks!
Re: cross tabulation question [message #37310 is a reply to message #37308] Wed, 30 January 2002 08:21 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
see if this helps...
http://asktom.oracle.com/pls/ask/f?p=4950:8:115419::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1355765880641,
Previous Topic: shared pool memory flush
Next Topic: default database
Goto Forum:
  


Current Time: Thu May 28 04:03:18 CDT 2020