Re: Many aggregates in one query

Mikito Harakiri wrote:
>
> Heinz Huber <hhuber_at_racon-linz.at> wrote in message news:<3B7D0AA9.4F9298C4_at_racon-linz.at>...
>
> > If you're using ASA 7 (and perhaps also 6), you can use the following query:
> > SELECT MIN(wsid), MIN(rowcnt)
> > FROM (SELECT wsid, COUNT(wsid) AS rowcnt
> > FROM test
> > GROUP BY wsid
> > HAVING COUNT(wsid) = MIN(COUNT(wsid)) t;
> >
> > Perhaps it works for other DMBSs, too.
>
> Not with Oracle:
>
> ORA-00935 group function is nested too deeply
> Cause: This is an internal error message not usually issued.
> Action: Contact Oracle Customer Support

That's why I wrote "If you're using ASA 7".

Heinz Received on Tue Aug 21 2001 - 08:08:10 CEST