Re: Question: Learning to Count(*)

From: Roger Stapley <rstapley_at_uk.oracle.com>
Date: Thu, 28 Oct 1999 20:51:53 +0100
Message-ID: <3818A959.E87980B7@uk.oracle.com>

select id,

         email
from     LIST
where    email in
         (
         select   email
         from     list
         group by email
         having   count(*) > 3
         )

Alex Skolnick wrote:
>
> I have been beating my head trying to figure out how to accomplish the
> following:
>
> I have 1 table that I want to retrieve all the accounts that have more
> than 3 emails. for examples
>
> ID: EMAIL:
> --- -----------
> 1 A_at_A.COM
> 2 A_at_A.COM
> 3 B_at_B.COM
> 4 C_at_C.COM
> 5 A_at_A.COM
> 6 A_at_A.COM
>
> I would like to see:
> ID: EMAIL:
> ---- -----------
> 1 A_at_A.COM
> 2 A_at_A.COM
> 5 A_at_A.COM
> 6 A_at_A.COM
>
> I am familar with Count(*) and Count(column_name), but How can I use
> it in the case of a where statment: In pseudo-code it would like
> this:
>
> select id, email from LIST where count(email) > 3
>
> Any help would be appreciated.

Received on Thu Oct 28 1999 - 14:51:53 CDT