Re: enumerate domain of column as new columns.. count

Ed, A multi-word question:
How can DECODE produce a cross-tab?

Ed Prochak <edprochak_at_magicinterface.com> wrote:

>
>This is a relatively simple case, so I have a one word suggestions for
>you: DECODE()
>
>(IOW, check out using the decode function.)
>
> ed
>
>tone wrote:
>>
>> hey everyone.. i cant figure out the answer to this. Id like to do it
>> in SQL/PLSQL if it can be done. ie. i would rather not have to mess
>> with java..
>> this is the result of a select statement (select app, apptype,
>> count(*) from table1 group by app, apptype;)
>>
>> app type count
>> app1 A 3
>> app1 B 2
>> app2 A 1
>> app2 C 2
>> ...
>>
>> im trying to get it to look like this
>>
>> app A B C Total
>> app1 3 2 0 5
>> app2 1 0 2 3
>>
>> and for the life of me, i cant figure it out.. i cant even describe
>> the problem in db terms.
>>
>> can someone, anyone help me.. ???
>> -confused intern at big company..
>> ps. i have to go fetch the coffee now. the life of an intern. ya gotta
>> love it!

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Tue Jul 09 2002 - 13:16:40 CDT