Re: Using Group By with Expressions

patrick_at_pcgi.com wrote:
>
> Hi.
>
> I'm using Oracle 7.2. I have a SQL Statement that looks roughly
>
> like this:
>
> SELECT TBL.COL1,
>
> TBL.COL2,
>
> DECODE ( TBL.COL3, "Value", TBL.COL3, TBL.COL4 ),
>
> SUM ( TBL.COL5 )
>
> FROM TBL
>
> GROUP BY COL1,
>
> COL2,
>
> ????
> ...

Patrick,

try rhis:

SELECT TBL.COL1,

       TBL.COL2,
       DECODE ( TBL.COL3, "Value", TBL.COL3, TBL.COL4 ),
       SUM ( TBL.COL5 )

         COL2,
         DECODE ( TBL.COL3, "Value", TBL.COL3, TBL.COL4 );

Hope this helps

Detlev

-- 
Detlev Goebel

mailto:detlev.goebel_at_gzs.de
---------------------------