Question: Learning to Count(*)

From: Alex Skolnick <anon_at_anon.com>
Date: Thu, 28 Oct 1999 19:15:51 GMT
Message-ID: <38199fb0.86484920@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 - 14:15:51 CDT