Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Subqueries and group by
Hi,
my problem:
I would like to use a subquery within a group clause.
Example:
select partner.name, (select age from person where partner.pid=person.pid)
from partner
group by partner.name, (select age from person where partner.pid=person.pid)
I get the error:
select partner.name, (select age from person where partner.pid=person.pid) from partner
*ORA-00979: not a GROUP BY expression
Any ideas?
Best regards
Ralf Wegener Received on Wed Aug 22 2001 - 04:07:13 CDT