Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> what wrong with this statement?
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
Received on Wed Mar 15 2006 - 13:18:31 CST