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

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!

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com