Re: SQL statement question

From: Yong Huang <yhuang_at_indigopool.com>
Date: Thu, 7 Sep 2000 11:46:49 -0500
Message-ID: <8p8gvn$8r$1@news.sinet.slb.com>

Should be the outer count().

BTW, what's the use of this query? It always returns 1 anyway.

Yong Huang
yhuang_at_indigopool.com

Jimmy <anonymous_at_anonymous.com> wrote in message news:39B87462.9749954A_at_anonymous.com...
> Hello all,
>
>
> THe following SQL statement:
>
> select count(count(*)) from table_a group by field_a having count(*) >
> 1
>
>
> Is the count(*) in the having part refer to the inner count(*) (or
> outer count(*)) in the select part? Maybe the answer can be known by
> testing, however, could anyone explain how Oracle resolve the above
> query?
>
> Thanks,
> Jimmy
Received on Thu Sep 07 2000 - 11:46:49 CDT