How to get rows by counting

admin

Administrator
Staff member
Hi there!
I searched the forums but I didn磘 find a real solution for my problem...I guess it磗 a simple answer, so I say "SORRY!" from the beginning.

Ok, this is my table

date | userID
-------------------
2001-12-01 | 1
2001-12-02 | 1
2001-12-03 | 1
2001-12-04 | 1
2001-12-01 | 2
2001-12-02 | 2
2001-12-03 | 2
2001-12-04 | 2
2001-12-01 | 3
2001-12-02 | 3
2001-12-03 | 3

What I want to achieve now, is that I want all the userID磗 that exist FOUR times...an SQL-Statement I would like to see it work is something like this...

SELECT * FROM WHERE (COUNT(userID) = 4)

But that doesn磘 work... :-(

Any ideas? That would be really nice...

Greetings...
 
Back
Top