Subqueries and group by

From: Ralf Wegener <rwegener_at_gmx.net>
Date: Wed, 22 Aug 2001 11:07:13 +0200
Message-ID: <9lvsob$hrp$05$1@news.t-online.com>

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