SQL statement question

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 Fri Sep 08 2000 - 00:08:50 CDT