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
Received on Wed Mar 15 2006 - 13:42:10 CST
