Re: Question: Learning to Count(*)

Thanks a mill guys!!

I wasn't even close

Thanks again.

On Thu, 28 Oct 1999 19:53:45 GMT, "Paul Q" <paulq_at_home.com> wrote:

>Step Method...
>
>
>CREATE TABLE JUNK
>AS SELECT COUNT(*),EMAIL
>FROM YOUR_TABLE
>GROUP BY EMAIL
>HAVING COUNT(*) > 3;
>
>SELECT * FROM JUNK
>WHERE EMAIL IN (SELECT EMAIL FROM JUNK);
>
>Alex Skolnick wrote in message <38199fb0.86484920_at_news.supernews.com>...
>>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 - 16:24:24 CDT