Re: help needed with query

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 12 Jun 2007 22:07:58 +0200
Message-ID: <466efd23$0$13771$426a74cc@news.free.fr>

"EdStevens" <quetico_man_at_yahoo.com> a écrit dans le message de news: 1181675768.517063.300740_at_z28g2000prd.googlegroups.com...
| Oracle 10.2.0.2.0
|
| I'm having a bit of trouble getting my head wrapped around this one.
|
| create table test_tbl (mgr_id varchar2(5),
| acct_code varchar2(5),
| inv_num number
| inv_amt number);
|
|
| Each mgr_id can have multiple acct_code. For each mgr_id, we need to
| see the sum
| of all invoice amounts where acct_code like 'A%'
| and sum of all invoice amounts where acct_code like 'B%'
|
|
|
| mgr_id act_code_A act_code_B
| ------ ----------- -----------
| smith 123.45 234.56
| jones 345.67 456.78
| snuffy 0.00 901.23
| bilbo 456.78 0.00
|
|
| not all mgr_id will have both acct_code groups.
|

Search for "pivot" on Google or AskTom.
Also http://www.psoug.org -> Morgan's Library -> decode

Regards
Michel Cadot Received on Tue Jun 12 2007 - 15:07:58 CDT