Volker Hetzer wrote:
> Nick schrieb:
>> when i input the following statement error occur:
>> select pubid,pubname,TITLE from (publisher natural inner join
>> journal) group by (pubid) having count(pubid)>1;
>>
>>
>>
>> error:
>> select pubid,pubname,TITLE from (publisher natural inner join journal)
>> group by (pubid) having count(pubid)>1
>> *
>> ERROR at line 1:
>> ORA-00979: not a GROUP BY expression
> pubname and title are not part of the group by expression, so oracle
> assumes that they differ within the group. Therefore it can't figure
> out which values to put into the one result row per group.
>
> Lots of Greetings!
> Volker
would you give me some example to use group by?
thanks!
Received on Wed Mar 15 2006 - 14:42:54 CST
