Re: Using Group By with Expressions

SELECT TBL.COL1,

        TBL.COL2,
        DECODE ( TBL.COL3, "Value", TBL.COL3, TBL.COL4 ) "Bad Billy's A*se",
        SUM ( TBL.COL5 )

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

/*+
The opinions expressed are mine and do not necessarily reflect those of Oracle Corporation
+*/ Received on Sat May 24 1997 - 00:00:00 CDT