Re: Not a group by expression

> Cause: The GROUP BY clause does not contain all the expressions in
> the SELECT clause. SELECT expressions that are not included in a group
> function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, must
> be listed in the GROUP BY clause.
> Action: Include in the GROUP BY clause all SELECT expressions that
> are not group function arguments.

Hi, I already included in GROUP BY clause all SELECT expressions that are not group function arguments.
And it runs OK in Oracle 8, but when I change version of Oracle in Oracle 9...then error start to appear.

Regards, Milica

>>Hello users. I have a query that I can run and see the result on the grid
>>on
>>design time, but when i run the program i get the folowing
>>message:ORA-00979: not a GROUP BY expression. When I run the same query
>>with
>>out parameters it runs and it was runing well before in Oracle 8.Also If I
>>don't use the GROUP BY function but with the parameter, it works also well
>>?What is the problem? The query is:
>>
>>select t1.id,t2.nad, max(t2.name) as name
>>from c02 t1, d00 t2
>>where t1.id = t2.id
>>and t1.date1 >= :pDate1
>>group by t2.nad, t2.id <-- is this supposed to be t1.id?
>
> From Oracle's website: http://tinyurl.com/78fgq
>
> ORA-00979 not a GROUP BY expression
>
Received on Thu May 12 2005 - 09:19:06 CEST