Re: ORA-00979: not a GROUP BY expression

"JZ" <ibm_97_at_yahoo.com> wrote in message news:10bc841c.0303251507.4d30b05d_at_posting.google.com...
> Oracle 9.2 on Linux:
>
> Query is:
>
> SELECT
> DISTINCT
> COUNT(SS_CNT_0) AS SG_1_SG
> ,SS_VAL_1 AS SG_2_SG
> ,SS_VAL_2 AS SG_3_SG
> ,SS_VAL_3 AS SG_4_SG
> ,'DEFAULT' AS SG_5_SG
> , MAX(SS_VAL_4) AS SG_6_SG
> ,'DEFAULT' AS SG_7_SG
> ,'DEFAULT' AS SG_8_SG
> ,'-1.0' AS SG_9_SG
> ,'DEFAULT' AS SG_10_SG
> FROM
> ( SELECT
> DISTINCT
> h.EVENTID AS SS_CNT_0
> ,TO_CHAR(h.APPTIMESTAMP,'HH24') AS SS_VAL_1
> ,TO_CHAR(h.APPTIMESTAMP,'HH24') AS SS_VAL_2
> ,n.DESCRIPTION AS SS_VAL_3
> ,MAX(h.NFSEVERITY) AS SS_VAL_4
> FROM
> HIGHSEVERITYEVENTS h
> , NFALARMS n
> WHERE
> h.NFALARMID = n.NFALARMID(+)
> AND h.APPTIMESTAMP >= TO_DATE('2003-03-24 00:00:00',
> 'YYYY-MM-DD HH24:MI:SS')
> AND h.APPTIMESTAMP < TO_DATE('2003-03-24 23:00:00',
> 'YYYY-MM-DD HH24:MI:SS')
> GROUP BY
> h.EVENTID
> , TO_CHAR(h.APPTIMESTAMP,'HH24')
> , TO_CHAR(h.APPTIMESTAMP,'HH24')
> , n.DESCRIPTION
> )
> GROUP BY
> SS_VAL_1
> , SS_VAL_2
> , SS_VAL_3
> ;
>
> The error is :
> TO_CHAR(h.APPTIMESTAMP,'HH24') AS SS_VAL_2
> *
> ERROR at line 18:
> ORA-00979: not a GROUP BY expression
>
>
>
> Any indeas? Thanks a lot!

Any reason why the distinct clause is there? You are selecting the same column and calling it different names. At least you should specify it only once (h.apptimestamp) in the group by clause.

I find this query to be quite senseless :) ... just my thought.

Anurag Received on Tue Mar 25 2003 - 20:57:57 CST