Re: Query Generating Horizontal Totals

Ask Tom, Great Resource!!! Thanks So Much!

Claudio.

Bricklen <bricklen-rem_at_yahoo.comz> wrote in message news:<U3eUb.6816$An3.5841_at_edtnps84>...
> tranvirus wrote:
>
> > Hi all,
> >
> > I have this table:
> >
> > Col1 Col2 Col3
> > A A1 5
> > A A2 3
> > A A3 2
> > A A4 4
> > B B1 6
> > B B3 8
> > B B4 1
> > C C1 3
> > C C2 5
> > C C3 8
> > C C4 2
> >
> >
> > I want to obtain this from my query:
> >
> > Col1 Col2 Col3 Col4 Col5
> > A 5 3 2 4
> > B 6 0 8 1
> > C 3 5 8 2
> >
> > I guess there shuld be a way of doing this
> > kind of operation in Oracle 9i but I don't
> > find the right SQL query. All the help will
> > be appreciated.
> >
> > Claudio Santana.
>
> check asktom.oracle.com for "transpose" or "pivot"
Received on Thu Feb 05 2004 - 11:45:06 CST