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...
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...